Pivot Table (column/row) label cache reset

K

Kris

Hello,

When updating the source date for a pivot table, and some categories being
no longer exist, they keep remaining in the label filter of the pivot table.
Refreshing the table updates the data area correctly, but no longer existing
rows, columns or report labels keep appearing in the filter drop down lists.

How can I 'reset' these without having to recreate the pivot table?

thx,
Kris
 
K

Kris

Thanks Ron,

I used the vb script because I had quite some tables. It's working just
fine!

Thanks a lot
Kris
 
R

Ron Coderre

Glad to help.

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table - Row Label Combination 0
Slicers and Calculated Items in Pivot Table 2
How to combine two column labels in a pivot table 1
VLOOKUP a Pivot Table Filter 0
How to Clear a Pivot Table Cache 1
Calculated column label in pivot table? 0
Pivot table layout that popluates the row label in each row? 3
Excel Pivot Table cache 2

Top