locked
pivot fields not updating RRS feed

  • Question

  • Hello. My pivot table fields aren't updating :( What to do? 
    Tuesday, October 25, 2016 10:35 PM

Answers

  • Hi AlexMartini,

    From there, click Options in Excel 2010 or earlier, or Analyze in Excel 2013 and later. This will show you a range of different options for managing your pivot table - the Refresh button(the highlighted in red ) and the Change Data Source button(the highlighted in yellow).

     
    The Refresh button will update your pivot table to reflect any changes in your existing data, such as any changes to our sales data due to customer returns. The Change Data Source button will allow you specify a new data source for your pivot table. Please refresh or change data source according your scenario and check if it is successful. For more details, please review this article.

    In addition, you can also try to copy/paste an existing Pivot table to create a new one, and check if it still has the problem.

    Best Regards,
    Angelia


    Wednesday, October 26, 2016 10:10 AM