Tips and Tricks·372 discussions

Web Hyperlink to Excel Worksheet

Locked

I need to create a hyperlink from a standard web page that will open Excel to a specific Worksheet Name in the workbook. There is much documentation on how to do this from within Excel (using the hyperlink function), but I can’t find an example thatshows how to do this from outside Excel.

Thanks.

Topic

Web Hyperlink to Excel Worksheet

In reply to Web Hyperlink to Excel Worksheet

The key is the # mark.

ExcelTest.xls

You can substitute a named range or cell for C4. Something like:

ExcelTest.xls#Total

Web Hyperlink to Excel Worksheet

In reply to Web Hyperlink to Excel Worksheet

I appreciate your answer, but this doesn’t work. The workbook still opens on the worksheet last viewed. I am using Excel 2000.

Web Hyperlink to Excel Worksheet

In reply to Web Hyperlink to Excel Worksheet

Go to http://WWW.Klippert.com/Excel for an example.

Web Hyperlink to Excel Worksheet

In reply to Web Hyperlink to Excel Worksheet

Using a hyperlink string such as ExcelTest.xls#Total!A1 only works under the following conditions:
1) User is using Internet Explorer
2) User has the file properties for an .xls file to “browse in same window” checked.

This unfortunately will not work for all web users since some may be using Netscape and/or have their file properties set other than what it needs to be.

Unless we have a solution that will work for every web user, it is not useful to us.

Web Hyperlink to Excel Worksheet

In reply to Web Hyperlink to Excel Worksheet

Have you tried creating a macro within Excel which will automatically open the Spreadsheet to a particular worksheet, then you can just use a standard link on your webpage

Reply To: Web Hyperlink to Excel Worksheet

In reply to Web Hyperlink to Excel Worksheet

This might be trying to over simplify the problem but…. Excel opens to the worksheet that was active (the one you were sitting on) when you clicked the save button. So open Excel go to the worksheet you want it to open to and then save.

Hope this helps.

[Author]

Replies