• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 272
  • Last Modified:

Open Excel file in Excel from HTM based hyperlink?

Running NT4 server (but not HTTP service) with W95 clients, local intranet, navigated with HTML menu pages. Hyperlinks will launch Excel files in browser window (IE4+), but some Excel functionality is lost.
Anyone know how I can use a hyperlink to force an XLS file to open inside Excel? HTML pages and Excel files are all located on the same NT server. HTML/Java/VB/ActiveX suggestions welcome.. Need more info let me know.
1 Solution
Change the mime types in the browser.

This behaviour is kind of annoying, but I have found one work-around that may be ok for you.

1. Create a shortcut to the excel file.
2. Let the HTML page refer to the shortcut (filename.lnk) instead of the Excel workbook file directly.

When the user clicks the link, he will be asked if he wants to run the application. The workbook will open in Excel if he says yes.

Ture Magnusson
Karlstad, Sweden
ajwnetAuthor Commented:
Sorry Seron, but needs to be a server/source based fix - don't like the idea of modifying the 25,000 client machines who have access to our company network.
As you say, Ture, it's a good workaround, if only it didn't require a confirmation..
Anyone else got an idea? I'd hoped there'd be a way of launching Excel using VB script... perhaps using shell?
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

None other than posing the question in the other relevant E-E sections too. Whether you try it with 0 point questions referering to this one or separate ones is up to you and your point/cash account.
I answered similar question:

Is it OK for you?
Open "My Computer" and go to menu View-Options-FileTypes.
Find the desired file type (for example, Microsoft Excel Worksheet), select it and click Edit...
Uncheck "Open web documents in place" and confirm your changes pressing OK.

ajwnetAuthor Commented:
Thanks yuk, best fixes are the simple ones. Discovered this early on - would be great if it didn't mean a configuration change on all 25,000 client machines. Been looking for a button/registry patch that can be made available on our intranet to provide one-click switch on/off in-browser activation for users. Still think there must be a java/vb solution somewhere out there that has no nags..
I compared the registry dump before and after changing this option. If this flag is unchecked, new value is added. Save the lines below to a *.reg file and run.



Good luck!

Oh, I forgot to mention it is for Excel 97. Do you need the fix for another version? The registry key should be close to the above one. Just uncheck the flag and search for BrowserFlags value in registry. It seems all classes have this flag checked by default.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now