Archive of Mr Excel Message Board

Back to Links in Excel archive index
Back to archive home

Urgent: Linking Problem

Posted by Wendy on November 14, 2001 7:56 AM

Why will my destination file only update if the source file is open? If the source file is closed, I get the error message: Unable to read file. Please help!

Re: Urgent: Linking Problem

Posted by Namir on November 14, 2001 8:36 AM

Not that this helps, but I have the same problem in Excel 97, only it just crashes.
My only suggestion is to examine your links (Edit: Links) and verify they're all kosher.
-Namir

Re: Urgent: Linking Problem

Posted by Wendy on November 14, 2001 12:24 PM

When I check my links, (edit: links), and do a check status, it says error: file not found. Do you think it could be something about the path?

Re: Urgent: Linking Problem

Posted by Namir on November 15, 2001 4:50 AM

Probably. Unless you have links to a lot
of workbooks, try relinking. Delete the link &
redo it. Also, if you changed the name of any linked
workbooks, Excel seems to freak out.
-Namir

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.