| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
entry removed from source table remains in pivot table pull down
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
entry removed from source table remains in pivot table pull down
Hi
Try dragging the relevant field back out of the Pivot Table to the Table Field List, then do a PT Refresh. Then drag the filed back to its required place in your PT. If this doesn't work for you, then Debra Dalgleish has some code at her site that will run through the whole range of items and clear thus that are not currently in use. http://www.contextures.com/xlPivot04.html -- Regards Roger Govier "EL in Melb." wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| entry not removed in pivot table pull down filter | Excel Worksheet Functions | |||
| Q: Change pivot table source path? | Excel Discussion (Misc queries) | |||
| Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
| Pivot table format changes if value of source data is null | Excel Discussion (Misc queries) | |||
| How do I view Pivot Table source data file and field names? | Excel Discussion (Misc queries) | |||
Linear Mode
