Find and Fix Pivot Table Source Data

After you create a pivot table, you might add or change records in the source data. Sometimes the pivot table does not update correctly, to show the new data. Or if you’ve inherited the pivot table file from someone else, you might not even be able to find the source data, in a large workbook.

To help with these problems, I’ve added a new page on my Contextures site, with tips for finding and fixing the source data for a pivot table.

On the new page, you’ll see how to:

  • locate the pivot table data source.
  • check the data source, to make sure it includes all the rows and columns that you need.
  • adjust the data source, to include new rows or columns.

For a long term solution to source data problems, the tutorial shows how to:

  • create a named Excel table, as a dynamic data source. It will adjust automatically, if new rows are added.
  • change the pivot table data source, so it is based on the new named Excel table.

There is a sample file that you can download, to follow along with the tutorial.

Watch the Video

If you’d rather see how it’s done, instead of reading the instructions, watch this short video.

________________

alt text: Find and fix pivot table data source problems http://www.contextures.com/excelpivottablesourcedata.html

________________