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.