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

Solution

The reason why rows label can't be updated is that pivot table can only refresh datas in values field. Solution as follows: 1. Open your PivotTable fields setting window, move the items("continent" in your case)from the row field to values field. 2. refresh PivotTable 3. move the items "continent" from values field back to rows field.

You'll see row label go back to what it is like in data source.

And this move won't change any of your other parameters settled before.