Excel 2007 pivot table filter question

lite4d

New member
Joined
Mar 10, 2014
Messages
2
Reaction score
0
Points
0
I have a spreadsheet that I have raw data and approx 40 pivot tables that I sort the raw data into. When I refresh all tables when new raw data is added, the label filter will not refresh and has to be manually refreshed. Is there any way to make the lable filter to refresh when all of the others do? Also when I send the file to others, they must reapply just that filter to see the data. I can post the file if needed.

Thanks

Chris​
 
File needed.
If too big, use MediaFire.com
Answer might be in Excel 2010 or later.
 
Excel Pviot Table Question

If you use the file attached, I can send it the file to someone and they must reapply the hours:minutes filter on the table to drill down into the information. Everytime that I add data and refresh all pivot tables on the original worksheet(which contains around 40 pivot tables) I must manually reapply the hours:minutes filter to each table. I cannot for the life of me figure out how to get the filter to refresh when all others do and to keep that applied when I send it to someone. Any help is greatly appreciated.

Chris
 

Attachments

  • Dec 2013.xlsx
    247.9 KB · Views: 7
Excel 2010, Tables, PivotTable
Never use negative dates/times/hours/minutes.
Always format dates and times in proper MS formats, not text.
Always use Tables for input/output data.
Use Structured References, never $A$1 or R1C1.
PivotTables like to retain the original data format when first created.
Delete PT and start over if input data format changes.
http://www.mediafire.com/view/49c0id939hu1ede/03_11_14.xlsx
 
Back
Top