Pivot Table (column/row) label cache reset

  • Thread starter Thread starter Kris
  • Start date Start date
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
 
Thanks Ron,

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

Thanks a lot
Kris
 
Glad to help.

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

Regards,

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