![]() ![]() 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. 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. 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. When this happens you have to choose the source for the links every single time you open the file from a different machine. ![]() Machine 2 Dropbox = C:\Dropbox\Excel Folder\Excel File Machine 1 Dropbox = C:\Dropbox\Excel Folder\Excel File 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: We now however wish to use Cloud Storage services e.g. 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. Within our company we use a number of Excel workbooks that link to other Excel workbooks.
0 Comments
Leave a Reply. |