PDA

View Full Version : Excel 2007 pivot table filter question



lite4d
2014-03-10, 04:50 PM
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

Herbds7
2014-03-10, 11:59 PM
File needed.
If too big, use MediaFire.com
Answer might be in Excel 2010 or later.

lite4d
2014-03-11, 12:25 PM
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

Herbds7
2014-03-11, 07:36 PM
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