If I link two files €“ save and close both then just open 1 of those, it
doesnt pick up the links/formulas and shows €˜#VALUE! for each cell, until
the other one is open too.
I manually linked them ie open 2 files; in one cell type €˜= then go to the
other file and link accordingly.

On the same note €“ sometimes I link the entire file or tab from the same
file (ie ctrl+K then select the file or tab) but often that also fails to
reopen.

First I thought its because I am linking different Excel files ie €˜Excel
97-2003 with xls (Excel 2007). Or xls with macro to xls without macro etc.
But even I tried linking the same files eg xlsm with xlsm €“ still the same
problem.

For future reference - do you reckon linking different excel files could
have caused this problem?

Thanks in advance