title: Excel Pivot Table Row Labels Not Refreshing
body: <p>To all,</p>
  
  <p>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:</p>
  
  <p>Row Label      Count</p>
  
  <p>North America    7 <br>
  South America    2 <br>
  Europe           5 <br>
  Asia             1 <br>
  Australia        3 <br></p>
  
  <p>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:</p>
  
  <p>Row Label      Count</p>
  
  <p>North America    7 <br>
  Antarctica       2 <br>
  Europe           5 <br>
  Asia             1 <br>
  Australia        3 <br></p>
  
  <p>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.</p>
  
  <p>Anyone able to solve this problem?</p>
  
  <p>Thanks - Mr. Do</p>