Forum Discussion

Copper Contributor

Nov 21, 2018

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

Formulas and Functions

Silver Contributor

Nov 21, 2018

Is OneDrive working properly on your system (does it synch)?

Ray-C
Copper Contributor
Nov 22, 2018
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.
- JKPieterse
  Silver Contributor
  Nov 22, 2018
  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.
  - Ray-C
    Copper Contributor
    Nov 24, 2018
    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