Linked spreadsheets #VALUE! issue

[EvansB2]

Hi there,

I seem to have trouble that I haven't had before and may be that I'm not using the full functionality of excel 2016. I have a simple master spreadsheet that is linked to multiple spreadsheets and unless I have the actual linked spreadhseet open, I get the #VALUE ! in the master spreadsheet cell. I've looked at editing links but can't find the solution.


Any assistance would be greatly recieved.


Regards

Ben

 

[DRSteele]

Do any of the links work?

I know that the #Ref error usually occurs when trying to use function INDIRECT with external references.

You can ensure that there are checkmarks next to Excel Options | Advanced | When calculating... | Update links to other documents and Save external link values.

Likely it is a problem that arises when workbook files were created in earlier versions of Excel; review these discussions and determine whether or not this is germane.
https://techcommunity.microsoft.com...inks-only-if-using-diff-version-of/m-p/136116
https://support.microsoft.com/en-us...culated-when-you-open-a-workbook-that-was-las
https://stackoverflow.com/questions...ting-data-from-closed-external-excel-workbook