I have a spreadsheet with a Pivot Table. The Pivot Table is generated via Power Pivot, and the underlying data is from a set of CSV files (one per month) that are linked by way of the Queries and Connections interface. Here is how the directory structure is:
C:\Users\Me\Documents\Reports\Monthly Report\Report-Master.xlsx
C:\Users\Me\Documents\Reports\Monthly Report\Raw Data\master-data-10-2017.csv
C:\Users\Me\Documents\Reports\Monthly Report\Raw Data\master-data-11-2017.csv
[...]
Now, I need to share this report to someone - the idea is to upload this to Google Drive and share the folder with the recipient. But it seems to me the absolute paths are used in the spreadsheet so I cannot do that - the recipient will have to update all the paths whenever they want to use the report, and I will have to set it back to my local directory structure when I need to. That all sounds sub-optimal to me. Is there a one true way to do this? Relative paths?
C:\Users\Me\Documents\Reports\Monthly Report\Report-Master.xlsx
C:\Users\Me\Documents\Reports\Monthly Report\Raw Data\master-data-10-2017.csv
C:\Users\Me\Documents\Reports\Monthly Report\Raw Data\master-data-11-2017.csv
[...]
Now, I need to share this report to someone - the idea is to upload this to Google Drive and share the folder with the recipient. But it seems to me the absolute paths are used in the spreadsheet so I cannot do that - the recipient will have to update all the paths whenever they want to use the report, and I will have to set it back to my local directory structure when I need to. That all sounds sub-optimal to me. Is there a one true way to do this? Relative paths?
