|
Pivot table clearing phantom page fields
The strange thing about clearing phantom fields is that it sometimes works,
but sometimes does not work. I can't find a modus or reason. When clearing phantom page fields (delete field from table, refresh table and add field again) fails, what options are left for the user ? I know of the VBA solution, but what solution is available without VBA. Or is this a well known Excel bug. -- -- Mark Rosenkrantz -- Spreadsheet Solutions Witkopeend 24 1423 SN, Uithoorn Netherlands -- W: www.rosenkrantz.nl E: -- |
Pivot table clearing phantom page fields
Debra Dalgleish shares both manual techniques and VBA solutions:
http://contextures.com/xlPivot04.html Spreadsheet Solutions wrote: The strange thing about clearing phantom fields is that it sometimes works, but sometimes does not work. I can't find a modus or reason. When clearing phantom page fields (delete field from table, refresh table and add field again) fails, what options are left for the user ? I know of the VBA solution, but what solution is available without VBA. Or is this a well known Excel bug. -- -- Mark Rosenkrantz -- Spreadsheet Solutions Witkopeend 24 1423 SN, Uithoorn Netherlands -- W: www.rosenkrantz.nl E: -- -- Dave Peterson |
Pivot table clearing phantom page fields
Dave;
Nice reply, but I allready knew that. The manual part did not work. But maybe I did not make it clear. -- -- Mark Rosenkrantz -- Spreadsheet Solutions Witkopeend 24 1423 SN, Uithoorn Netherlands -- W: www.rosenkrantz.nl E: -- "Dave Peterson" wrote in message ... Debra Dalgleish shares both manual techniques and VBA solutions: http://contextures.com/xlPivot04.html Spreadsheet Solutions wrote: The strange thing about clearing phantom fields is that it sometimes works, but sometimes does not work. I can't find a modus or reason. When clearing phantom page fields (delete field from table, refresh table and add field again) fails, what options are left for the user ? I know of the VBA solution, but what solution is available without VBA. Or is this a well known Excel bug. -- -- Mark Rosenkrantz -- Spreadsheet Solutions Witkopeend 24 1423 SN, Uithoorn Netherlands -- W: www.rosenkrantz.nl E: -- -- Dave Peterson |
| All times are GMT +1. The time now is 03:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com