Forum Discussion
Error from Excel External Reference Formula
It appears to sync. However, when I open the same file via the WEB Interface (not from my computer) I also get an error Message "Links Disabled Links to external workbooks are not supported and have been disabled". If I klick on the same cell that holds a formula (in my computer based version of excel), I get the following information displayed in place of the formula "This cell has an external reference that can't be shown or edited. Editing this cell will remove the external reference".
Thank you for your kind assistance.
- That is by design, Excel on-line is not capable of calculating links to external files. They should work when opened on your desktop Excel though.
Thank you for coming back to me.
Yes, my perception is that it should work when I open it on my desktop Excel but that is my problem, it doesn't and I get the error messages.
When I contact Office 365 support, they tell me that it is a OneDrive problem, when I have tried to get to the bottom of the problem via OneDrive Support, I am told that it is an Office 365 problem.
Could anyone help to steer me to location where I might get some support to get to the bottom of the problem.
Thank you
- 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.
