| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table (column/row) label cache reset
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table (column/row) label cache reset
Debra Dalgleish's website has instructions:
http://www.contextures.com/xlPivot04.html Also, the Pivot Play PLUS add-in at her site will clear them: http://www.contextures.com/xlPivotPlayPLUS01.html Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Kris" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table (column/row) label cache reset
Thanks Ron,
I used the vb script because I had quite some tables. It's working just fine! Thanks a lot Kris "Ron Coderre" wrote in message ... Debra Dalgleish's website has instructions: http://www.contextures.com/xlPivot04.html Also, the Pivot Play PLUS add-in at her site will clear them: http://www.contextures.com/xlPivotPlayPLUS01.html Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Kris" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table (column/row) label cache reset
Glad to help.
-------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Kris" wrote in message ... Thanks Ron, I used the vb script because I had quite some tables. It's working just fine! Thanks a lot Kris "Ron Coderre" wrote in message ... Debra Dalgleish's website has instructions: http://www.contextures.com/xlPivot04.html Also, the Pivot Play PLUS add-in at her site will clear them: http://www.contextures.com/xlPivotPlayPLUS01.html Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Kris" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table (column/row) label cache reset
Thanks Ron. I had a similar issue and your inputs helped me overcome it.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Default Weight in Pivot Table Charts keeps getting reset | Charts and Charting in Excel | |||
| Excel Pivot Table cache | Excel Discussion (Misc queries) | |||
| How to delete column label from pivot table field | Excel Worksheet Functions | |||
| Pivot Table - Formats Reset... why? | Excel Discussion (Misc queries) | |||
| Reset a caption for a Pivot Table | Excel Worksheet Functions | |||
Hybrid Mode
