6

On a wiki page, I would like to create a link to an Excel document stored in the Documents folder on SharePoint, that opens the Excel file in Excel Online.

When I create the link using Insert -> Link -> From SharePoint, I can select the Excel document. However, when clicking on the link, my browser (IE10) downloads the Excel file to my local hard drive.

I would like the file to open in my browser in Excel Online. Is there a way to do this?

We use SharePoint 2013.

4

Append Web=1 to the url to instruct it where to open. Of course you have to have all the prereqs in place.

/PWA/ProjectBICenter/Documents/AllXLDashboards.xlsx?Web=1

Opens it in Excel Services web page

/PWA/ProjectBICenter/Documents/AllXLDashboards.xlsx?Web=0 

Opens it in excel

1

Check the settings in the document library your Excel file is hosted in. In Settings -> Advanced Settings, you have should have "Open in the browser" as your default open behavior.

EDIT: If the above doesn't work, change the link's behavior (Page --> Edit --> Link) to "Open in new tab." This should force the document to open in Excel Online.

  • Alas, this didn't help. When I click on the Excel file in the Documents folder, it indeed opens in Excel Online. However, when making a link on a wiki page the way I describe above, my browser still downloads the file instead of opening it in Excel Online. Same behaviour with a link of the form [[List:Documents/mydoc.xlsx]] – JanFrederik Dec 12 '14 at 8:13
  • Have you tried checking "Open in new tab" in the Link behavior? I looked over my setup again and I have that feature turned on, that may be what opens it in the browser in the first place. – MattCoats Dec 12 '14 at 15:13
  • "Open in new tab" doesn't change the behaviour :-( – JanFrederik Dec 16 '14 at 14:21
0

Try to Change the Stylesheets as described here: http://www.andrewjbillings.com/sharepoint-20102013-content-query-web-part-please-open-in-office-web-apps-ugh-i-loathe-you-right-now/

  • Can you please add brief details from the link. Links tend to break in future. – Asad Refai May 10 '16 at 9:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.