show items with no data option in pivot tables
 

Can anyone help with some bizarre results I'm experiencing with the show
items with no values check box in the field settings menu for pivot tables.
It appears to be showing field headers that don't exist in my data????

I'm using Excel 2000.

Debra Dalgleish has some techniques at:
http://www.contextures.com/xlPivot04.html

In fact, she has an addin that you may like:
http://www.contextures.com/xlPivotAddIn02.html

AHuntington wrote:

Can anyone help with some bizarre results I'm experiencing with the show
items with no values check box in the field settings menu for pivot tables.
It appears to be showing field headers that don't exist in my data????

I'm using Excel 2000.

--

Dave Peterson

There's information here on clearing old items in a pivot table:

http://www.contextures.com/xlPivot04.html

AHuntington wrote:
Can anyone help with some bizarre results I'm experiencing with the show
items with no values check box in the field settings menu for pivot tables.
It appears to be showing field headers that don't exist in my data????

I'm using Excel 2000.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html