Forum Discussion
Linking workbooks across multiple operating systems
fuschia If you switch to OneDrive, you'll be able to have multiple users collaborate in real-time. You can even have users in the desktop client version of Excel and Excel for the web at the same time.
Smitty Smith Do users still work off the same "local" copy when collaborating?
I guess it's a bit easier for me to explain with a diagram and steps to recreate the issue:
User 1 updates Actual Revenues
User 1 updates Revenue Report
User 2 updates Actual Labor
User 2 updates Revenue Report
The current issue is that when User 2 (or any beyond User 1) tries to update the Revenue Report file, all of the links are using the addresses of the files on User 1's computer. Is there a way for the files to be set up or linked in a way that users don't constantly need to change the source to point to the copies on their local machines?
Doing research, I see G Suite allows for the use of the https://www.blog.google/products/g-suite/g-suite-pro-tips-how-sync-one-spreadsheet-another-google-sheets/ function which allows the links to be static to a URL. I see that Microsoft is https://excel.uservoice.com/forums/274580-excel-for-the-web/suggestions/10366332-links-between-spreadsheets-in-excel-online. However, I'm wondering if there is a workaround in the meantime.
I haven't seen much regarding Collaborating in OneDrive beyond working on the same file simultaneously (as that's the primary goal of the feature). Is it powerful enough/set up to handle this as well? What files would need to be set to collaborate, and would there be a specific user in mind that would need to do this (i.e. the business owner "sharing" the file with managers)?
Thanks so much for your help.
