Excel Services – SharePoint Exception error

If you receive an exception error if you try to open the sample workbook or another workbook through SharePoint try the following steps:

As the message states, the spreadsheet needs to come from a trusted location.  This can be set up as follows:

1. Open Central Administration -> go to Operations tab

– ensure that the Excel Service is running

2. Open Central Administration -> go to your configured Shared Service -> click Excel Service Settings

–  File Access Method:  ensure that it is not using Impersonation, instead the Option Process Account should be enabled.

3. Open Central Administration -> go to your configured Shared Service -> click add new trusted file location

– field URL: here you can specify a report library or the whole portal

– Location Type: should be Windows SharePoint Services

– Children trusted: defines whether the children should also be trusted or only the defined path

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s