View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tim Zych Tim Zych is offline
external usenet poster
 
Posts: 389
Default linked files to be changed

Links can get complicated to construct, are you sure you got the "syntax"
correct? Replace does work.

--
Tim Zych
SF, CA

"mohavv" wrote in message
...
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