Linking to a Particular Excel Worksheet from a Web Page
For example, if a workbook named Test.xls is stored on a Web server named "Elk.extension.psu.edu," use the following syntax to create the link:
<a href="http://Elk.extension.psu.edu/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. There's no guarantee that a particular worksheet will be displayed when the workbook is opened in a browser.
However, it is possible to control the worksheet that is displayed when your Web browser opens a particular workbook.
How To Link to a Particular Excel Worksheet from a Web Page
- Add the following text to the anchor tag in the Hypertext Markup Language (HTML) code: #sheetname!range_or_definedname 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 example, 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://Elk.extension.psu.edu/test.xls#Sheet3!B5:D10">Text for the link.</a> If you want to link to the MyRange defined name on Sheet2, use the following syntax: <a href="http://Elk.extension.psu.edu/test.xls#Sheet2!MyRange">Text for the link.</a>
- Note: http://Elk.extension.psu.edu is used for example purposes only.
- Also, you should replace "Text for the link" with whatever your link text should be.