MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Getting excel services to work. What am I missing?

  Asked By: Nicholas    Date: Jan 02    Category: MOSS    Views: 2522

We have a test MOSS server up and some of the users want to start
playing with Excel Services (we do have the enterprise CAL)

I have gone to Central Admin > SSP and set the Excel Services Trusted
File Location as the url of our root site of the site collection and
selected 'children trusted'

In the site collection administration pages, I went to SITE FEATURES and
made sure ENTERPRISE SITE FEATURES was activated.

However, our users still get permissions errors. Am I missing a step? Do
individual sites need to be trusted? Do users somehow have to be granted
permission (these are site admins at the moment).

They're also asking if an external network share can be 'trusted' for
MOSS. I really don't know much about excel services yet, but it's my
understanding that to use it, one would have to have the excel file
physically uploaded to their sharepoint site, correct?



1 Answer Found

Answer #1    Answered By: Elaina Suarez     Answered On: Jan 02

Not sure what the issue is for the Permission errors  you mention. Can users  browse to the document library at all? Do you need to give your users additional permissions? Permission errors sounds like a MOSS issue and not anything specific to Excel SErvices. If you have the exact error message that could be helpful.

Regarding your other question...You CAN load files from a network  share. You will need to create trusted location  of type "UNC" for that location, as in "\\server\sharename". You probably would also want to check the "Children Trusted" checkbox for this. If you are using files from UNC you may need to change the "FileAccessMethod" to "Process Account". This is a global setting. This is the auth method used by Excel Services to retrieve workbooks from non-doclib locations.

Didn't find what you were looking for? Find more on Getting excel services to work. What am I missing? Or get search suggestion and latest updates.