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...
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.