Forum Discussion
Error from Excel External Reference Formula
Using Office 365, I have a worksheet where cell's contain formula's that point to information (a table of address information related to an index) held in an external workbook (in a different excel f...
I just tested this on my own OneDrive. If I refer from one workbook to another, save both files and then open the SOURCE workbook and change the linked cell, exit and then open the TARGET file, the new value is correctly displayed. Even so, if I open the Edit links dialog and click the Check status button, Excel warns me that values to other workbooks were not updated. Even though they were apparently updated as I can see the new value.
Looks like this doesn't work as it should. I'll try to make the Excel team aware of this issue.
Looks like this doesn't work as it should. I'll try to make the Excel team aware of this issue.
I played both with ODFB and OneDrive Personal and was not able to reproduce - links are updating and Edit Links shows OK status.
However, it looks like that or similar issue exists for about 3 years https://onedrive.uservoice.com/forums/913528-onedrive-on-the-web/suggestions/7178317-add-option-to-avoid-onedrive-from-changing-excel-r.
Perhaps depends on OneDrive client version, not sure. Anyway, my one 18.192.0920.0015.
And I didn't play with symlinks if it changes something, it looks like they could help with old client (groove.exe)