How to open xls sharepoint link with excel and not the browser.
I have a link list library which list items link to my document library that havexls documentsand other external xls documents.... I created web page to display those links, but when I opena xls document link list,the xsldocumentis opened in thebrowser... i can see that because the link is created by the URL of the librarydocument xls. If open the XSL document from the document library, then MS EXCEL will open the document. Is there a wayto open my XLS link items by MS EXCEL and not by the browser.. Thanks forany advice on this...
March 30th, 2008 7:13pm

Hi, The standard way is to use document libraries since they make the job . You could convert your link list to an XSLT view and make the necessary code to apply a specific way of opening for XLS files....Better, you could create your own link list and deploy it as a solution so that it can be reused everywhere in your farm but it's a bit of work. Out of the box, you won't find a solution except just using document libraries Regards
Free Windows Admin Tool Kit Click here and download it now
March 30th, 2008 9:52pm

Probably best to use the same method as SharePoint, which uses JavaScript.... Code Snippet var stsOpen=null; try { stsOpen=new ActiveXObject("SharePoint.OpenDocuments.2"); } catch(ex) { alert("Exception while opening the Active X object I will open the document as a normal link."); return; } stsOpen.ViewDocument2(window, link, ""); return false; HTH, Vince
March 30th, 2008 9:52pm

Thanks for your advice..
Free Windows Admin Tool Kit Click here and download it now
March 31st, 2008 8:37am

Thanks you for your answer.. where do i use this code in the default page (default.aspx )..?
March 31st, 2008 8:40am

You wuold need to include it where you were going to use it. Either in the page (if you are only using it in one place) or in the master page if you are going to use it often. It would need to be wrapped into a function... function OpenDocument(link) { // Code here.. } and then used in an <a> tag... <a href="javascript: OpenDocument(docLink)">Doc Name</a> HTH, Vince
Free Windows Admin Tool Kit Click here and download it now
March 31st, 2008 10:24am

Here is the best way to open XL, XLS, XLSX or any Office Document in Excel, Word, PowerPoint, and any other native Office application and not the browser for SharePoint 2010: You'll need to be an Administrator (Full Control of SharePoint site) AND possibly also be a Site Content Administrator. Navigate in your browser to the site (or sub-site) where the document library is that you want to change. Now navigate to that actual document library (where it shows you the list of documents and/or folders. In the top menu you'll see "Library Tools"; click Libary and then click Library Tools (far right "settings" menu section) In the "General Settings" section on this next page you'll see a command for "Advanced Settings", click and open that. On that next page, third option setting down is: "Opening Documents in the Browser" Specify whether browser-enabled documents should be opened in the client or browser by default when a user clicks on them. If the client application is unavailable, the document will always be opened in the browser. Over to the right are 3 radio buttons, with the heading- Default open behavior for browser-enabled documents: Select "Open in the client application". Scroll down and click the "Okay" button. Now, anytime a user clicks on an Excel, Word, PowerPoint, or other Office Document in this library, at pop-up dialog box will appear asking if they want to open in the associated Office application, or save the document on their local PC. I hope this helps! - Todd Rawlings
December 12th, 2010 10:33am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics