| 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 |
| 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 | |||
Threaded Mode
