Hi Dave,

Sorry, you can't do that ...

If your new workbook is closed without ever being saved, then there's nothing left for the other one to link to. Hence the error.

Cheers

--
macropod
[MVP - Microsoft Word]


"Dave" wrote in message ups.com...
| Hello everyone
|
| I posted this question a few days ago and got no response - I'm hoping
| this will be a clearer explanation.
|
| I client has presented me with a number of Excel files that he wants
| linked to a master spreadsheet. These are all *.xls files, and are
| about 11k in size, and are updated periodically from Access.
|
| When I link a new workbook (target) to one of these files (source),
| the link works until I close the target. Then, if I try to update the
| link (EditLinksUpdate Now) I get an "Unable to read file" message.
|
| If I save the target, the file size jumps from 11k to 19k, and the
| links work perfectly. At first I thought this might be a version
| issue, but running Activeworkbook.Fileformat in VBA on the original
| file comes back with -4143 (Excel 97/2000). I'm running Excel 97, so
| I tried it on a friend's system with Excel 2003, got the same
| results.
|
| I'm running out of ideas, any insight into this would be greatly
| appreciated.
|
| Regards,
|
| DaveU
|