Is there a way to specify the range that the Pivot Table references when getting external data from an Excel spreadsheet? I have my Pivot Table working, but I just need this last part to make it more efficient.
Is there a way to specify the range that the Pivot Table references when getting external data from an Excel spreadsheet? I have my Pivot Table working, but I just need this last part to make it more efficient.
Not sure if I understand you correctly, but try this
In the external file
- create a named range for the source of your data
In the file containing your pivot table
- click on Change Data Source
- amend the source so that it refers to the named range in the other file
.
PivotSource.jpg
If you have both files open when amending the data source, Excel should correctly insert file path to the external file (when that file is closed)
Last edited by kev_; 04-11-2018 at 02:24 AM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Thanks! This was what I was looking for. It seems to have worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks