MORE INFORMATION
Typically, when you create a link from a Web page to a Microsoft Excel
workbook, the path used in the link refers only to the Uniform Resource
Locator (URL) for the workbook. For example, if a workbook named Test.xls
is stored on a Web server named "sample.microsoft.com," use the following
syntax to create the link:
<a href="http://sample.microsoft.com/test.xls">Text for the link.</a>
When you click such a link, your Web browser opens the Test.xls workbook, and the worksheet that was active when the workbook was last saved
becomes the active worksheet. Because of this design, there is no guarantee
that a particular worksheet will be displayed when you open the workbook in your
Web browser.
However, it is possible to control the worksheet that is displayed when your Web browser opens a particular workbook.
To do this, add the following text to the anchor tag in the Hypertext Markup Language (HTML)
code
#<sheetname>!<rangeordefinedname>
where <sheetname> is the name of the worksheet you want to display (for
example, Sheet1) and <rangeordefinedname> is the name of the range (for
example, A1 or B5:D10) or defined name (for examplel, MyRange) that you
want to select.
For example, if you want to create a link that opens Test.xls when you
click it, switches to Sheet3, and selects the range B5:D10, use the
following syntax:
<a href="http://sample.microsoft.com/test.xls#Sheet3!B5:D10">Link
text.</a>
If you want to link to the MyRange defined name on Sheet2, use the
following syntax:
<a href="http://sample.microsoft.com/test.xls#Sheet2!MyRange">Third
link.</a>
If you are using a list or some other method of linking to workbooks, the
syntax used to create the link may vary, but the syntax used to link to the
worksheet, range, or defined name remains the same, for example:
<option value="http://sample.microsoft.com/test.xls#Sheet3!B5:D10">