About Us

Dave Peterson

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot Table Page fields	Ajit	Excel Discussion (Misc queries)	1	October 12th 05 05:49 PM
Pivot Table page fields	Chad W.	Excel Discussion (Misc queries)	1	July 27th 05 04:27 PM
How do I set up filter for page fields in pivot table?	Mitsycat	Excel Discussion (Misc queries)	3	May 6th 05 10:27 PM
Pivot Table Page Fields	Andy	Excel Discussion (Misc queries)	1	December 17th 04 05:25 PM
Iterating through Page Fields of a Pivot Table	TommyVee	Excel Programming	1	September 23rd 04 11:03 PM

Menu

About Us