| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I Clear old Pivot Table Fields that no longer exist
How can I clear old Field Names that show up on the filter list but no longer
exist in original data table (Pivot Table Source Data) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I Clear old Pivot Table Fields that no longer exist
Try right-clicking in the table and selecting Refresh Data.
"snowman" wrote: How can I clear old Field Names that show up on the filter list but no longer exist in original data table (Pivot Table Source Data) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I Clear old Pivot Table Fields that no longer exist
You have a few options....all available at Debra Dalgleish's website
For instructions and the vba code to run: http://www.contextures.com/xlPivot04.html OR....for the Pivot Play add-in the clears the items for you: http://www.contextures.com/xlPivotPlay01.html Does that help? *********** Regards, Ron XL2002, WinXP "snowman" wrote: How can I clear old Field Names that show up on the filter list but no longer exist in original data table (Pivot Table Source Data) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Total Not Summing Correctly on Calculated Fields in Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table Size | Charts and Charting in Excel | |||
| New fields not showin up in pivot table. | Excel Discussion (Misc queries) | |||
| repeating names in row fields of a pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
Linear Mode
