Hyperlink Formula

[jstevens]

Is it possible to reference the active workbook name in the formula?

Example: =HYPERLINK("[ActiveWorkbook]MySheet!A1", "<<<Back")

[HansV]

You can use # to refer to the active workbook:

=HYPERLINK("#MySheet!A1", "<<<Back")

[jstevens]

Hans,

I receive an error message: Reference is not valid.

[HansV]

Does the actual sheet name contain spaces or punctuation?

[jstevens]

Hans,

It fails because there are blank spaces in the sheet name such as "My Sheet". It works fine if the sheet name does not contain blanks in it ie "MySheet".

[jstevens]

Hans,

The resolution is to place an apostrophe in the formula before and after the sheet name.

=HYPERLINK("#'My Sheet'!A1", "<<<Back")

[HansV]

Yes, that is the same as in a cell formula: if you refer to a worksheet whose name contains spaces or punctuation, you need to enclose its name in single quotes (apostrophes).