Excel hyperlink worksheets to other workbooks

A

Al Kinnamon

How can I hyperlink worksheets from one workbook to another workbook? Just
the sheet not the entire workbook?
 
D

Dave Peterson

One way is to use Insert|Hyperlink and use an address like:
C:\My Documents\excel\book2.xls#'sheet two'!a1
(You'll have to include a range, too.)


You could also use a worksheet formula:

=HYPERLINK("#"&CELL("address",'C:\My Documents\excel\[book2.xls]sheet two'!C5),
"click here")

(all one cell)
 
G

Gord Dibben

Al

AFAIK, you can't.

If you have a hyperlink on sheet1 of book1 to sheet4 or a bookmark of book2
and click on it, Book2 will open to sheet4 or the bookmark.

What exactly are you wanting to do that would not involve opening the target
workbook?

Gord Dibben Excel MVP

On Fri, 8 Oct 2004 12:15:02 -0700, "Al Kinnamon" <Al
 
Top