links issues

  • Thread starter Thread starter freekrill
  • Start date Start date
F

freekrill

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

The links in x.xls change to look for their values in z.csv. Even whe
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 hav
links set to automatic update.

Thanks
fre
 
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).
 
Back
Top