Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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?

share|improve this question

2 Answers 2

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.

share|improve this answer

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.

share|improve this answer
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

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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