Forum Discussion

Frank Robertson's avatar
Frank Robertson
Copper Contributor
May 17, 2018

Excel file to ONLY reference another open workbook

Greetings all,        I am trying to create a standalone Excel pivot table that pulls data from another open workbook but whenever I send it to someone, it has references to my file paths.  Here is...
BI & Data Analytics
Need Help
Al C's avatar
Al C
Copper Contributor
May 27, 2018

Hi Frank, I don't think this is possible. The situation you described is a perfect scenario for:

  1. A shared file system where you can direct link the PivotTables to an underlying data source in a shared folder
  2. Store your main data file online and use Google Sheets or https://www.coda.io?utm_campaign=msft-tech-alchen&utm_medium=social&utm_source=microsoft&utm_content=excel-answer

Otherwise the user will have to change the file name every time they open the workbook.

Resources