Windows 7, Excel 2010 I have inserted data on a single worksheet that populates around 10 pivot tables, each on their own worksheet. One of the data f Is there an easy way to update the data source for multiple pivot tables on a single Excel sheet at the same time? All of the pivot tables reference the same named range, but I need to create a second worksheet that has the same pivot tables, but accessing a different named range. In a new sheet (where you want to create a new pivot table) press the key combination (Alt+D+P). In the list of data source options choose "Microsoft Excel list of database". No, you never type anything into a pivot table. A pivot table is a report on data that is held elsewhere. In an Excel list, or a SQL database or some such. You need to understand that the pivot table is just a view of the source data. All changes to the data must happen at the source, not in the view. Tried Refresh Table to update the pivot table. My experience with the Refresh Table will update the values in the data that I've used to create the pivot table with. My issues is adding additional rows to the data and having these new rows added to the pivot table. for example, creating a pivot table asks the range of cells to create the table with, A1-G343. This Excel tutorial shows you how to create pivot tables based on a dynamic named range that will expand as you add additional rows of data. This can be a huge time saver and helps to protect against inadvertent errors that result when pivot tables draw from only part of the data source. Hello, I was trying to follow the steps listed in the “Copy a Pivot Table and Pivot Chart and Link to New Data” article, but after re-linking the copied pivotchart, excel 2007 simply remove the old pivotchart formating (colors, labels, captions, etc). Great help than you very much. I had the issue of my Pivot tables updating before the External Data Source refresh had finished. So on the sheets that hold the external data source I added, you code to update PivotTables on data change (I think its working, and data and Pivot tables in Sync) I have a spreadsheet with 8 pivot tables (PT's) in it. The master pivot table sources from another spreadsheet (data source). All other PT's source from the master PT. Join Dennis Taylor for an in-depth discussion in this video, Using source data from a table to make your PivotTable more dynamic, part of Excel Tips Weekly.