Forum Discussion
Change Data Source in Excel pivot table shows the correct changed range, but displays the old range
I have been updating a set of Excel tables and associated pivot table charts monthly for months, by using Change Data Source each month to shift the selected table range to include the latest month's data. But this month, I cannot do that. I select change data source, I select the new range, and the description of the new range appears in the little window, but in the chart page, the old table appears, and nothing I can figure out to do will get the chart table to reflect what its changed range specification signifies. And I tried this on a different machine with a different instance of the original datasheet, just see if it was a computer-specific issue, but no, the same problem occurred on the other machine, so it's an Excel thing. I tried googling this, and others seem to have the same issue, but no helpful answers were provided. Hitting refresh or refresh all did not help.
1 Reply
- While you're using the term 'tables' for your data sets, it appears the PivotTable is looking at a static range. Every so often the new data comes in and the pivot must be updated manually.
I'd have to see the workbook to have a look at the quirk you're experiencing. Have you tried converting your range to a table and then setting the pivot table source as the table?
