PowerPivot Data Refresh with Excel Source Data
So wouldn’t you know, one of the source files that we get to load into PowerPivot is Excel. Initially the data was being loaded into the PowerPivot Window using either the Linked table or the Copy & Paste options. I immediately decided to change this option to help streamline the process and decided to use the ‘Excel File’ import option under the ‘From Other Sources’.