MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Linking previously linked workbooks

Posted by Dale Hagopian on December 06, 2001 10:53 AM

Hi fellow Excel gurus!
Okay, I've had a workbook "X" linked to a workbook "Y"
for about a year. I split "X" into X1 to X5, then I
split "Y" into five workbooks also. All the cells in
(for example) Y3 are linked to the correct workbook X3,
but whenever I open Y3 it's still looking for the old
workbook name "X" and obviously can't find it.
So after I point it to the correct workbook, and the
linked cells all update, I save Y3 and close it. But
whenever I open Y3, it once again wants to link to X,
not the X3 it should. It just won't "remember" that I
want it to link to the new X3 and not the original X.

Any help? When I get the "File not Found" box, and I
change the Advanced part to reflect the new file, it
never saves.

Help!!! Thanks!

Posted by Hansoh on December 06, 2001 12:27 PM

can't promise this will help, but i did a simple test, replicated your problem, and fixed it. doesn't hurt to try.

open all of your files. go to a Y file that references an X file. in the Y file, go to EDIT-->LINKS. then select all of the X-referenced files in the listbox, click on CHANGE SOURCE to the correct/updated X files, and that should do it.

note: it may make a difference how many sheets there are in any given Y file. if there's more than 1, you MAY have to do with for each sheet. hope it helps.