Pivot table refresh problem with filters
-
Wednesday, July 18, 2012 12:59 PMI have several pivot tables in a worksheet with various filters applied to the columns in the tables. When I refresh the pivot tables my filters are changed seemingly with no pattern. What can I do to maintain the designed filtering upon refreshing the pivot tabels?
All Replies
-
Thursday, July 19, 2012 6:58 AMModerator
Hi,
Could you please tell me how you apply the filters to the columns?
And when I tried in my computer, I cannot reproduce the issue.
About set filters to a table, please refer to the following link:
http://office.microsoft.com/en-us/excel-help/filter-data-in-a-range-or-table-HP010342517.aspx
Jaynet Zhang
TechNet Community Support
.png)
