Hyperlink from HTML to a specific Excel workshhet

W

WayneO

We have html files with links in them that open an Excel document and goes to
a specific worksheet. Since upgrading from Office 2003 to Office 2007 we
now find that the link will only open the workbook to its last saved active
worksheet and not the worksheet required. Does anyone know how to get around
this? HTML Syntax is <a href="c:\temp\book1.xlsx#Sheet3!A1"> LableName </a>
 
G

Gary''s Student

Using 2007 I created a tiny workbook called master.xlsx The only thing in
master is a hyperlink to another workbook, specific sheet, specific cell.

I saved master as html.

When I open the htlm in IE, the hyperlink works.

Examine the html in NotePad to see the syntax.

(to me the htlm is just gibberish)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top