Forum Discussion

Ray-C's avatar
Ray-C
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
Ray-C's avatar
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

JKPieterse's avatar
JKPieterse
Silver Contributor
Nov 26, 2018
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.

Resources