Need help with Pivot Filter not maintaining value

Help. I have a pivot table on top of a data set that is constantly changing. I have set a pivot filter to a specific value but as the data gets refreshed, new values appear checked off on the pivot filter without me doing it. Additionally, if the data set does not contain the value I selected in the filter, i want it to show nothing, however, it randomly picks from the list. I don't know what to do and this is causing all kinds of issues.

Please help

August 8th, 2013 5:25pm

you may see some items checked in filter box but is it displayed on sheet ?

It happens probably because excel try to optimize resource.

Free Windows Admin Tool Kit Click here and download it now
August 9th, 2013 1:24am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics