How to turn off Excel opening documents in the browser with SharePoint Enterprise

Written by Sean Wallbridge on. Posted in SharePoint, SharePoint 2010

Got SharePoint Enterprise and as such, Excel Services installed? Well, just like the Office Web Apps, Excel may be trying to open XLS/XLSX files in the browser. You can either turn off the default behavior to open in the browser in each Document Library but if there are a number of them or the client doesn’t want this at all, you can turn off the browser based default by doing the following:

 

  1. Go to the Site Collection Settings Page
  2. Activate the feature Open Documents in Client Applications by Default”

 

020811 0515 Howtoturnof1 How to turn off Excel opening documents in the browser with SharePoint Enterprise

 

020811 0515 Howtoturnof2 How to turn off Excel opening documents in the browser with SharePoint Enterprise



Incoming search terms:

Trackback from your site.

Sean Wallbridge

Sean Wallbridge, President and Principal Consultant of itgroove Professional Services Ltd, is a 6 time SharePoint MVP and Evangelist from Victoria, British Columbia, Canada. Sean likes to characterize himself as a “SharePoint Jedi” (there are no experts, just those who continue to explore the enormous ways of the SharePoint force) and there is no better way to describe Sean’s enthusiasm for SharePoint! Sean and itgroove specialize in bringing a rich, professional SharePoint experience to the small and mid-size companies that form the backbone of business in British Columbia and Canada. In addition to being a SharePoint MVP, Sean has a rich background in the Windows world and carries many certifications including CISSP, MCSE, MCT and MCSA. Sean has lived and worked internationally (Bermuda) and still carries on an international consulting practice from his base at itgroove in Victoria

Comments (7)

  • Webasua

    |

    This didn’t work for me.  Still tries to open files in the web browser.

    Reply

  • Larry W Virden

    |

    I have an issue where .xlsx documents are opening within the web page, even though the doc library itself is set to use external applications. I went to the settings as defined above, but there was no feature available for Open Documents in Client Applications by Default.

    Where does that come from?

    Reply

    • Marek Hlavac

      |

      I know this is a little bit late, but in case someone comes across…check if you have permissions for Client integration, and a 32-bit IE.

      Reply

  • Andrew Brooks

    |

    I think this is down to individual browser settings, as I have the same thing. Can open Word docs in Word, but Excel files want to open in the browser…the rest of my users can open in Excel!

    Reply

  • Steve Harcharran

    |

    I had the same issue, Came to find out that the end user was using IE 8 with 64-bit. Switched to IE 8 with 32-bit. Now the user was able to open Excel document from Sharepoint 2010 in Excel instead of IE. Success

    Reply

  • Craig Johnson

    |

    I think Andrew is right on the mark.
    Had a user today who was getting this same problem even though Collection Setting was correct.
    Once I got them to try IE (instead of Chrome) it worked fine – so it might be a browser thing.

    Reply

  • tom

    |

    thank you

    Reply

Leave a comment