I am not sure about the syntax, but at least in Excel 2007 you can create a
hyperlink to another place in a document by right-clicking on a cell,
choosing Hyperlink, and then on the left-hand side of the window that opens
choose 'Place in this document'.

"Matt" wrote:

I'm trying to create a hyperlink using the hyperlink function that
will go to a separate tab within the same worksheet. What I'm using
is: =HYPERLINK("'Tab1'!A1","Cell1") , but it is telling me it
cannot open the specified file. Can anyone help?
.