I am constructing a workbook that is linked to various other workbooks on our network and have come across a particular issue regarding the external references
I enter the following formula into a cell:
and the result is #VALUE!
Further to this the formula in cell D21 refers to the same workbook (but is just a plain count function)
and does NOT return an error but the result of the formula
ALSO......when I open the other workbook the errors change to results of formulas (weird???)
I have updated the links when I open the workbook and I see there is no reason why a result would be achieved from one formula and not the other (except perhaps that the workbook needs to be opened for the formula to calculate - which is really silly)