I don't have another guess.

Spreadsheet Solutions wrote:

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

--

Dave Peterson