Hyperlink to other spreadsheets in other workbooks

[recben]

I would like to hyperlink to a particular spreadsheet in a different workbook.

It seems easy to link to spreadsheets within the workbook, or to other books, what do I need to type in the 'type the file name' to link to a spreadsheet within that workbook?

Thanks for your help.

RECBEN

 

[jdc]

hyperlink to place in another workbook

Hi

If I have understood you correctly, just add #Sheet2!B3 straight after the filename with no space between, it is basically a bookmark in the other workbook.

This would hyperlink to whatever workbook sheet2 cell B3 in this instance

hope this helps

John

 

[hatman]

I highly recommend the use of the Hyperlink() worksheet function for this application. There are several syntaxes, depending upon whether the linked file is open or closed, and whether there are spaces in the File/Pathname. But I tend to use the follwoing syntax to cover all combinations:

'Data'!$A$1","Link")

You'll notice that the entire File/Path is contained in Square Brackets. The way that I build this is to open BOTH workbooks, then in a cell off to the side, I simply type in =, and switch to the destination book, and select the destination cell. Then I CLOSE the destination book. This causes Excel to build the FULL file/pathname in the Source book. Then I simply copy/paste the full addrss sstring to the Hyperlink() function, and move the leading Square Bracket from it's normal position to the FIRST position in the string, and adust the Single Quotes accordingly (included around the Sheet Name, but not in the File/Pathname).

The syntax is TRICKY, so it may take you a few tries to get it right. Good Luck.

 

[hatman]

BTW: THIS is a good resource for Hyperlink info, among other stuff... you just have to weed through some extaneous stuff.