SUMMARY
This step-by-step article explains how to create a link from a Web page to a particular
worksheet, range, or defined name in a Microsoft Excel 2000 workbook.
Normally, when you create a link from a Web page to a Microsoft Excel
workbook, the path 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, the Test.xls workbook opens in your Web
browser, 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 is displayed when you open the workbook in your
Web browser.
back to the top
Link to a Particular Worksheet
You can control which worksheet is displayed when you
open a particular workbook in your Web browser. 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 that 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 example, MyRange) that you
want to select.
For example, if you want to create a link that opens Test.xls, 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>
Link to a Named Range
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 that you use to create the link may vary, but the syntax that you use 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">