View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mohavv mohavv is offline
external usenet poster
 
Posts: 68
Default linked files to be changed

Hi,

I have a large file with a lot of links to other files.

All of them change twice a year. I copy all the files to a new folder,
rename them (all files begin with the year number) and manualy change
the links thru /edit/links

I've tried to use the replace function to replace the text in the
linked cell, but that didn't work.

Is there a solution to how to do this more simple.

cheers,


Harold