Excel Pivot Table Row Labels Not Refreshing

Question

To all,

I have an Excel spreadsheet pivot table that is linked to an SSAS data source. The employee counts are aggregated and return the following values:

Row Label Count

North America 7
South America 2
Europe 5
Asia 1
Australia 3

Let's say the user modifies the South America Row to read "Antarctica" by accident, and then the spreadsheet is saved. Now we have the following:

Row Label Count

North America 7
Antarctica 2
Europe 5
Asia 1
Australia 3

Which we know is wrong. I refresh the data and the counts can change, but the row label remains "Antarctica" and does not change back to "South America". I've check a number of Excel Pivot table settings but to no avail.

Anyone able to solve this problem?

Thanks - Mr. Do

Answer 1

The overwritten row item can be refreshed by the following steps:

• Drag the row field out of the pivot table.
• Right click on the pivot table and select 'Refresh'.
• Drag the row field back onto the pivot table.

Answer 2

You can delete pivot table and create it anew
Not sure if this method is good enough for you :)

Answer 3

Hi, set sorting on the row and set autosort(default). This should solve Your problem.