ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   linked files to be changed (https://www.excelbanter.com/excel-discussion-misc-queries/166551-linked-files-changed.html)

mohavv

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

Tim Zych

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





All times are GMT +1. The time now is 02:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com