Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Column widths get changed when another user opens my files | Excel Discussion (Misc queries) | |||
How to avoid when linked source data is changed, chart turns blan. | Charts and Charting in Excel | |||
Excel Files Changed | Excel Discussion (Misc queries) | |||
links changed since tranferring files from old to new laptop | Links and Linking in Excel | |||
My files changed from A - Z to Z - A. How do I change this back? | Excel Discussion (Misc queries) |