Prev: Need help on a formula
Next: ID number to Gender
From: Peter Cummuskey on 20 May 2010 00:25

For some reason, this solution didn't work for me, so I put together a
formula that when used in conjunction with the HYPERLINK formula
sidesteps the issue quite well.

=CONCATENATE(SUBSTITUTE(LEFT(CELL("filename"),FIND("]",CELL("filename"))-1),"[",""),"#")

Define the formula as DocLocation and specify hyperlinks as:

=HYPERLINK(CONCAT(DocLocation, "Sheet2!A1"), "Go to Sheet 2")

Emulating relative links like this isn't ideal, but it gets the job
done if nothing else works, and doesn't rely on macros.




--
Peter Cummuskey
 | 
Pages: 1
Prev: Need help on a formula
Next: ID number to Gender