Hi

In excel I want a document register hyperlink to change depending on the status of the work – Live or Archive, so it then automatically changes the hyperlink address for the original file to the appropriate folder that the file has been moved to.

Any ideas? There’s loads of files in this register, the main problem we have is when files are archived the hyperlinks currently need redone

Thanks

[Edited on 22/7/14 by Mr Whippy]

Linkfixer Plus will do what you want, it's fairly expensive and not that easy to use but will do exactly what is required

I have used it many times on migrations and such like, moving hundreds of thousands of files at a time

David

a combination of an IF and CONCATENATE should work?

Think this will work...

put the prefix for live in A1, e.g. \livesvrcurrent
put the prefix for archived in B1, e.g. \archivesvrarchived
type live in A2
put a filename in B2
select c2 and type the following formula =HYPERLINK(CONCATENATE(IF(A2="live",$A$1,$B$1),B2))
change a2 to something other than live...and see it magically change...


[Edited on 22/7/14 by stevebubs]

omg its a formula function...

that's superb, well done that's so going to be a big help