Linking to a Particular Excel Worksheet from a Web Page

Typically, when you create a link from a Web page to a Microsoft Excel workbook that is stored on a Web Server, 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 "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

1. 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.
   
   
2. 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.