hyper linking

[thenine]

Hello,

I need some help with hyperlinking. I know how to hyperlink from a
cell, to a word document, to an excel document, and even to other cells
or worksheets within the same document.

My question is how do you hyperlink from a cell to a specific worksheet
inside of a seperte excel file?


basically i want to click on a link in one excel file and have that
link pull up a specific worksheet inside of difrent excel file.

Thanks for the help

 

[Jake Marx]

Hi thenine,

You can do this with the HYPERLINK worksheet function:

=HYPERLINK("[c:\book1.xls]Sheet1!G70","Go to Book 1")

Regards,

Jake Marx
MS MVP - Excel