Hi Robin,
Let's start with something everybody with Excel 2000 up
can work with.
Create a new workbook and save it
I named mine 2004-08-05-Robin.xls
(My default file location is C:\bk1\h\excel2k )
Ctrl+A, apply borders to all cells with toolbar button
or with Format, Cell, Borders, inside borders & outside borders
Apply borders also to sheet3
Rename 'Sheet3' to 'Other Sheet3'
that puts a space into the worksheet name for a
more complete example.
Into cell C4 enter 'C4-1
Into cell B50 enter 'B50-1
Return to Sheet1
Select C5 place = in cell then select C4 on 'Other Sheet3'
return to sheet1
Ctrl+K, then
Select C6 place = in cell then select B50 on "Other Sheet3'
return to sheet1
File, Save As
save entire workbook (checked)
2004-08-05-Robin.htm
save as type: Web page *.htm, *.html
Save
Go to the directory where you have your workbook and HTML file
Click on 2004-08-05-Robin.htm
You will also notice that Excel creates an HTML file (11 KB) and
a folder (43.3 KB) with the same name, you need everything on
your website. If I created them myself sheet1 woulb be 2 KB
and the other sheet 5 KB, and I would have had to code out
the HREF myself, but it does show you show the cost of making
HTML look exactly like Excel and have round tripping.
You will see that the hyperlink used here is a bit different
than if you created the HTML yourself without the clickable
sheet tabs.
file:///C:/bk1/h/excel2k/2004-08-05-Robin_files/sheet003.htm#RANGE!C4
file:///C:/bk1/h/excel2k/2004-08-05-Robin_files/sheet003.htm#RANGE!B50
file:///C:/bk1/h/excel2k/2004-08-05-Robin_files/sheet001.htm#'Other Sheet3'!D5
But in answer to your question, perhaps it might have sufficed
to say that you create the hyperlinks as object hyperlinks
within Excel *before* converting to HTML.
The HYPERLINK Worksheet Function will not work when
converted to HTML. I actually include this in the above
example: in cell A8 just to see what would actually happen:
=HYPERLINK("#'Other Sheet3'!D5","see Other Sheet3 cell D5")
Actually it comes closer than I would have expected so
it just might be possible in a later version of Excel
(mine is Excel 2000), for instance in Excel 2002 and up
the following is valid
=HYPERLINK('Other Sheet3'!D5,"see Other Sheet3 cell D5")
so you might try that and let me know what happens,
I doubt that it would generate HTML that works on a website.
a different method of specifying the link portion.