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")

Hi,

Why don't you simply select the cell then

Insert|Hyperlink
Select Place in this document and select your sheet.
You can specify a particular cell and text to display.

Mike

"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")

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")

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

These formulas will adjust if you change the sheet name or insert/delete
rows/columns on the "sending" sheet.

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")

--

Dave Peterson

The issue with your formula is that it is missing the file extension ".xls" after the workbook name "Test". Also, the exclamation mark should come before the sheet name, not after. Here's the corrected formula:

In this formula, replace "A1" with the cell reference you want to link to in Sheet3.

1. When you click on the cell with this formula in Sheet1, it will take you to cell A1 in Sheet3 of the same workbook.