show items with no data option in pivot tables

[Guest]

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]

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

 

[Debra Dalgleish]

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

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