Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables
I use the wonderful pivot a lot. I use SQL to get dvolitile data and then
refreash the pivot. Is there a way to "scrub" the pivot memory without starting all over, i.e., data in the pivot select is persistant from the prior refreshed even when not in the current data set. Its correctly not in the final pivot, but continues to appear in new select list? thx in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables
There are instructions here for clearing old items from a pivot table:
http://www.contextures.com/xlPivot04.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html "cww" wrote: I use the wonderful pivot a lot. I use SQL to get dvolitile data and then refreash the pivot. Is there a way to "scrub" the pivot memory without starting all over, i.e., data in the pivot select is persistant from the prior refreshed even when not in the current data set. Its correctly not in the final pivot, but continues to appear in new select list? thx in advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables
thx!! most helpful
"Debra Dalgleish" wrote: There are instructions here for clearing old items from a pivot table: http://www.contextures.com/xlPivot04.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html "cww" wrote: I use the wonderful pivot a lot. I use SQL to get dvolitile data and then refreash the pivot. Is there a way to "scrub" the pivot memory without starting all over, i.e., data in the pivot select is persistant from the prior refreshed even when not in the current data set. Its correctly not in the final pivot, but continues to appear in new select list? thx in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |