Try it this way:

=HYPERLINK("#"&"sheet3!A1","click")

# means current workbook, and you need to specify the cell that you
are jumping to.

Hope ths helps.

Pete


On Jul 14, 9:25*am, Tor Einar
wrote:
My workbook's name is Test.xls. By clicking a specific cell in sheet 1, I
want Excel to jump to sheet 3 in the same workbook. What is wrong with my
formula:
=HYPERLINK("(Test)Sheet3!";"Click")