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...
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?
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?