Excel may not know where is source data is:

1. start with no files open
2. open or create the file with the source data in it
3. leaving the source file still open, open or create the file with the links
4. save the source file
5. close the source file
6. examine the links in the link file. the paths should be correct
7. save and close the link file
8. if you re-open the link file the linked data should still be good.
--
Gary''s Student - gsnu200802


"Salman" wrote:

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