Pivot table page field problem

[roseberryv]

I have set up a pivot table with a page field for account name. I'm
having a problem where I select an account from the page field drop
down box, but when the pivot table updates, some of the time it shows
data for a different account. For instance, if I select Supplies, the
page field will show Supplies after my choice, but if I double click on
a cell in the table itself, the resulting data is for Travel expense.
It's not consistently wrong, just sometimes. Has anyone else had this
problem, and if so, how did you fix it?

 

[Debra Dalgleish]

Perhaps some of the captions were accidentally changed. You could
manually fix them, or reset them programmatically. My pivot table add-in
has code that will reset them for you:

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