Shared excel external references

Question

Dear all, 

For work I use different excel files, which in many cases are linked to each other. So there are cells in some excel sheets that link to another cell in another excel sheet.

Recently, I needed to share my excel worksheets with other teammates, so I uploaded the files to a shared onedrive folder, I updated the links so the cells would search the sheets inside the shared folder. However, we have a problem, when my teammates open the sheet it tries to find data on the same exact place where it is saved on my computer. So for example there is a cell in a sheet that is linked to C:\Users\username\OneDrive\projects.... on my computer, but my teammate has an other username than mine, so the link does not work on his computer, if he tries to exchange the links on his device, so that they work there, mine goes wrong and so on. 

Since the previous problem, we decided not to exchange links on his computer just mine, but there is another problem. I try to explain it in an example: I write data into one excel worksheet, called 'hours'. There is another worksheet, called 'summary', in which there are many linked cells from 'hours' worksheet. So when I write data in 'hours' I expect to automatically update info in 'summary'. It does update, when I on my computer open 'summary'. However, my teammate does not see the new info in the 'summary' until I on my computer do not open the 'summary' excel and save new data.

Our projects are saved in excel 97-2003 compatibility mode, we saved them in xlsx but it did not help.

Answer 1

Hello,

Your issue with your Microsoft OneDrive is out of the Microsoft Community's scope of support. Because of this, I recommend submitting your concern to our OneDrive Email support.

To do so, you may follow the steps below:

1. Sign in to OneDrive.com using any browser.
2. Click the? icon (Help icon) on the top banner of the page.
3. Select  Email OneDrive support, submit your concern and then follow the prompts to request support.
4. You can also visit OneDrive help center for additional help.

If you would like me to provide additional advice, simply respond to this thread. I will get notified and I’ll reply to you as soon as I can.

Regards