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 €“ or €“ vlookup, sumif etc to another excel
file.

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.
If I open the source file, it corrects the formula in the other file but if
I only open the linked file (while source file is not opened) €“ it shows
€˜#VALUE!.
Is there any way to get rid of this error without even opening the source
file otherwise I will have to open and close alot of files before I start
work on any Excel file as most of my files are linked to many other files. At
present its taking alot of time to open all other files, save and then close
those to get rid of €˜#VALUE! errors. I was wondering if there is any other
way to get rid of these errors.

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

Thanks in advance