![]() |
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 |
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