HTML link to open specific tab (worksheet) in Excel 2016 workbook RRS feed

  • Question

  • I have seen this question posted but no good answer.  I have a Excel 2016 generated web page (.mht) and an Excel workbook all stored on a SharePoint 2016 site.  I have generated .png's on one of the Excel worksheets in the workbook and published that page only as an .mht file.

    I need to be able to insert a hyperlink on the .mht page that corresponds to a specific tab (worksheet) in the workbook.  When I create a hyperlink in Excel it will only open to the last page viewed and ignores the syntax to open to the specified sheet.  

    Does opening a link to a specified Excel tab work from the browser to an Office application such as Excel.

    Wednesday, December 12, 2018 7:17 PM