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