Mr Whippy
|
| posted on 22/7/14 at 10:29 AM |
|
|
Excel Hyperlink problem
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]
|
|
|
|
|
Minicooper
|
| posted on 22/7/14 at 11:00 AM |
|
|
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
|
|
|
AntonUK
|
| posted on 22/7/14 at 06:13 PM |
|
|
a combination of an IF and CONCATENATE should work?
Build Photos Here
|
|
|
stevebubs
|
| posted on 22/7/14 at 07:44 PM |
|
|
Think this will work...
put the prefix for live in A1, e.g. \\livesvr\current\
put the prefix for archived in B1, e.g. \\archivesvr\archived\
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]
|
|
|
Mr Whippy
|
| posted on 23/7/14 at 11:38 AM |
|
|
omg its a formula function...
that's superb, well done  that's so going to be a big help
|
|
|
