Hi.
I faced strange behaviour of cells' values that are set as links to other workbook in the following manner:
='\\servername\foldername\[ExternalSource.xlsx]Sheet1'!A1
In general, there are 3 workbooks. One of them is external source which I refer to in way I've mentioned above. Other...