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!
-Dale
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.
han
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.
Archive of Mr Excel Message Board
