Cannot Open PivotTable Source File Fix

When downloading a pre-built Excel dashboard, or moving one around on your computer, you might experience an error. The error will come up and say 'Cannot open PivotTable source file' and then include the file name.

The simple fix is to disconnect all slicers, remove the original file name from the PivotTable data source, and then reconnect the slicers.

In the video, you can see I disconnect my slicers, and then remove the original filename from the data source leaving only 'RAW'. 'RAW' is the table name that is on my 'RAW' data tab.

 

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Download the Keyword Categorisation Template!
  You will receive a download link via email. We hate spam and never share your details.
Download the Google Analytics Dashboard
  You will receive a download link via email. We hate spam and never share your details.