Hyperlink to spreadsheet

[av8r]

How can I hyperlink to a perticular sheet within a workbook? Thanks in advance.
P.S. I am trying to hyperlink from my website to a spreadsheet.
This message was edited by av8r on 2002-02-26 04:51

 

[Aladin Akyurek]

On 2002-02-26 03:39, av8r wrote:
How can I hyperlink to a perticular sheet within a workbook? Thanks in advance.

=HYPERLINK(Data!A1,"Data")

entered in some cell in a worksheet, different from Data, which is the name of the worksheet of interest you want to hyperlink.

 

[Mudface]

Or just choose Insert -Hyperlink from the menu, select your file in the top box (leave empty if it's within the same spreadsheet) and select the location within the file in the bottom box.

 

[Chris Davison]

On 2002-02-26 03:39, av8r wrote:
P.S. I am trying to hyperlink from my website to a spreadsheet.

if you want the HTML to hyperlink to a specific sheet in Excel : go to the sheet and name cell A1 "linktohere" or something appropriate...

then the HTML command will be

{A HREF="filename.xls#linktohere"}description{/A}

it follows the same basic logic as anchoring to another HTML document