Within our company we use a number of Excel workbooks that link to other Excel workbooks.
With our service this is fine as everyone accesses a shared network drive and the file paths for all the linked files remain the same.
We now however wish to use Cloud Storage services e.g. Dropbox but have run into issues. With all of the services we have tested the file path for files is different for every machine.For example the same folder on two different machines would have file locations as below:
Machine 1 Dropbox = C:[machine 1]\Dropbox\Excel Folder\Excel File
Machine 2 Dropbox = C:[machine 2]\Dropbox\Excel Folder\Excel File
When this happens you have to choose the source for the links every single time you open the file from a different machine. If you create a file with links to other files on machine 1 and then move to machine 2, machine 2 no knows where the files with 'machine 1' in the path as stored. This is a huge barrier for us using this kind of storage as every user would have to change each file each time they open it.
It becomes particularly acute when using PowerPivot and linking to other files in the data model as all of the data model data sources have to be updated also.
I understand why this happens, but is there a way to get around this and have files link together in such a way that the links are relative rather than absolute.
We are using a mix of Office 2013 and 2016