Pivot table changes the name of a value

MMGroup

Board Regular
Joined
Jul 10, 2002
Messages
50
Excel 2003, Windows XP.
Dataset:
Account Type
Account Name
Amount

Pivot Table:
Left Hand column:
Account Type
Account Name
Data section: Sum of Amount

Account Names consist of some 50 unique names.
This pivot table has been working properly for several years.
Suddenly, one of the Account Names appears in the Pivot Table with a completely different name! Changing all entries of the account name to some other value changes the Pivot Table to the new value. Changing all entries of the account name back to the original name causes the pivot table to show the original completely different name.

I've moved the file to another computer running Excel 2003 and the problem is replicated.

My first thought was there was a NAME value, however there are no NAMEs defined (Insert : Name : Define)

Got me stumped.
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Solved the problem

I tried something I didn't expect to work, but it did. If one types over the Account Name value on the Pivot Table, Excel remembers it. I simply typed over the displayed value with the desired value. I guess it makes sense, just had never thought I could change that.
 
Upvote 0

Forum statistics

Threads
1,222,246
Messages
6,164,805
Members
451,917
Latest member
WEB78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top