Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables
Hi,
If I copy a worksheet with a pivot table and delete the list on which the pivot is based then the pivot has no data upon refreshing but the dropdown still contains some data from the last list. Is there any option to delete that too.. Please suggest |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables
If you remove the column, row, or page field from the layout. Then refersh
the data and add the field back to the layout it will be blank. "Ranjit" wrote: Hi, If I copy a worksheet with a pivot table and delete the list on which the pivot is based then the pivot has no data upon refreshing but the dropdown still contains some data from the last list. Is there any option to delete that too.. Please suggest |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to create multiple Pivot tables at once | Excel Discussion (Misc queries) | |||
#REF in Sheets that refer to Pivot Tables | Excel Discussion (Misc queries) | |||
Refreshing Pivot Tables linked to Oracle Datasource | Excel Discussion (Misc queries) | |||
Dynamically changing several pivot tables at once | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) |