Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Pivot Table cache
I've significantly modified the data in cells upon which a pivot table is
based. However, when refreshing the pivot table, the pick lists it provides for the various data element in the pivot table include all the values that were present in the original source data cells. For example, one of the columns of data is "Facility Name". My data table only has 4 unique facility names, but there are nearly 20 listed in the pick list based on what had been present earlier. Is there a way to "reset" or "clear" this memory cache so that the pick lists will include only items currently in the data source? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Pivot Table cache
Try this remedy
http://www.contextures.com/xlPivot04.html -- Regards, Peo Sjoblom "bonxie" wrote in message ... I've significantly modified the data in cells upon which a pivot table is based. However, when refreshing the pivot table, the pick lists it provides for the various data element in the pivot table include all the values that were present in the original source data cells. For example, one of the columns of data is "Facility Name". My data table only has 4 unique facility names, but there are nearly 20 listed in the pick list based on what had been present earlier. Is there a way to "reset" or "clear" this memory cache so that the pick lists will include only items currently in the data source? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Pivot Table cache
Thanks - that did the trick!
-bonxie "Peo Sjoblom" wrote: Try this remedy http://www.contextures.com/xlPivot04.html -- Regards, Peo Sjoblom "bonxie" wrote in message ... I've significantly modified the data in cells upon which a pivot table is based. However, when refreshing the pivot table, the pick lists it provides for the various data element in the pivot table include all the values that were present in the original source data cells. For example, one of the columns of data is "Facility Name". My data table only has 4 unique facility names, but there are nearly 20 listed in the pick list based on what had been present earlier. Is there a way to "reset" or "clear" this memory cache so that the pick lists will include only items currently in the data source? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007: Pivot sharing same cache? | Excel Discussion (Misc queries) | |||
Excel cache appliance | Excel Discussion (Misc queries) | |||
Pivot Cache - Massive Spreadsheet | Excel Discussion (Misc queries) | |||
Pivot cache | Excel Discussion (Misc queries) |