Excel First

Excel Solutions

Change Pivot Table Data Source

now browsing by tag

 
 

Can’t Open Pivot Table Source file

Can’t Open Pivot Table Source…

Like a good Excel fan, I switched to Excel 2016 to try the new version.

While working on a Dashboard for a client, with a lot of Pivot Tables and charts in it, at some point, after moving some pivot tables and charts into other sheets, within the same workbook, I received this unexpected error message – Can’t Open Pivot Table Source:

Cannot Open Pivot Table Source file

Can’t Open Pivot Table Source file

Read More