I have a file (x.xls, say) which has links to another file (y.xls). I
save y as z.csv and then close it.

The links in x.xls change to look for their values in z.csv. Even when
I re-open y.xls x.xls is still linked to z.

Is there a way of preventing the links in x.xls from changing? I have
links set to automatic update.

Thanks
free


--
freekrill
------------------------------------------------------------------------
freekrill's Profile: http://www.excelforum.com/member.php...fo&userid=7561
View this thread: http://www.excelforum.com/showthread...hreadid=489043

How about just saving x.xls before you save y.xls as z.csv.

After you create z.csv, close x.xls without saving. Since you saved when it was
pointing at y.xls, it'll still be pointing at y.xls when you reopen it.

Or do all your work with x.xls closed--it won't know what the heck you did with
y.xls (and won't care how many z.csv's you could have made).

freekrill wrote:

I have a file (x.xls, say) which has links to another file (y.xls). I
save y as z.csv and then close it.

The links in x.xls change to look for their values in z.csv. Even when
I re-open y.xls x.xls is still linked to z.

Is there a way of preventing the links in x.xls from changing? I have
links set to automatic update.

Thanks
free

--
freekrill
------------------------------------------------------------------------
freekrill's Profile: http://www.excelforum.com/member.php...fo&userid=7561
View this thread: http://www.excelforum.com/showthread...hreadid=489043

--

Dave Peterson