Linking Excel Files

S

Salman

If I link two files – save and close both then just open 1 of those, it
doesn’t 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
 
G

Gary''s Student

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.
 
S

Salman

Thanks Gary
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.
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top