Pivot table clearing phantom page fields

[Spreadsheet Solutions]

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.

 

[Dave Peterson]

Debra Dalgleish shares both manual techniques and VBA solutions:
http://contextures.com/xlPivot04.html

 

[Spreadsheet Solutions]

Dave;

Nice reply, but I allready knew that.
The manual part did not work.
But maybe I did not make it clear.

 

[Dave Peterson]

I don't have another guess.

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