Article ID: 197922 - View products that this article applies to.
This article was previously published under Q197922
There may be times when you want to use links or Microsoft JScript in a Web page to offer quick access to different parts of an Excel Document. For example, you might offer departmental statistics on an intranet site that links easily to charts or previous months' reports in the same document.
You can open an Excel 97 file to a named area, or any sheet and cell from a anchor link or script in an HTML page as long as the HTML page is accessed via http ( not by double-clicking it in Windows Explorer, nor using file://) and Excel is opened within the browser. If Excel is opened outside of the browser, it will not move to the specified link.
The syntax is based on standard Excel syntax. You can use this method in a frame declaration, an anchor tag, or even in script when using location.href.
This HTML demonstrates how the links and Jscript look:
Make sure you create an Excel file with a named cell, and change the HTML above to reflect the name of your Excel file, and the named area.
For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/178222/ )How to launch Word from Internet Explorer
(http://support.microsoft.com/kb/185978/ )FIX: Double GET requests and cookies are lost with Word 2000 or Excel 2000
(http://support.microsoft.com/kb/162059/ )Office documents open in Internet Explorer
(http://support.microsoft.com/kb/157417/ )XL97: Unable to use file URL in linking formulas
(http://support.microsoft.com/kb/189155/ )XL98: Unable to use file URL in linking formulas
Article ID: 197922 - Last Review: July 2, 2004 - Revision: 2.3
Contact us for more help
Connect with Answer Desk for expert help.