How do you set up Excel Services for SharePoint 2010?

I’ve installed the Office Web Apps (wcsetup.exe) and created a new Excel service in central administration.

But I’m now stuck on what to do next - do I need to turn it on in a document library?


You need to enable the "SharePoint Server Enterprise Site Collection features" Site Collection feature.

And Office Web Apps is not Excel Services. In Office Web Apps (is OWA the correct acroynom?) you have the Excel editor/browser which is not the same as Excel Services.


You first have to add your site collection url to the list of trusted excel services locations. After that you should have the option to open in web in any document libraries in that site collection.

  • 1
    Is that necessary in SP2010, isnt all of SP trusted now? – Wictor Wilen MCA MCM MVP Feb 2 '10 at 19:13
  • Well, you still have trusted locations but it does seem that by default if the url starts with http:// or your webapplication url then they are trusted. – Steve Lineberry Feb 2 '10 at 20:02
  • Yeah, that what was I thought (and verified now). Ie the difference between 2007 and 2010 is that 2007 has no default trusted locations and 2010 by default trusts all SharePoint sites hooked to the service app. – Wictor Wilen MCA MCM MVP Feb 2 '10 at 22:21
  • so I should be able to select the excel document in the library and have an option in the ribbon to view in the browser? – Rob Feb 3 '10 at 9:46
  • What are you trying to achieve; view it using the Office Web Apps or using the Excel Svcs? – Wictor Wilen MCA MCM MVP Feb 3 '10 at 14:47

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.