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.