Getting rid of error message “You do not have permissions to open this file on Excel Services. Make sure that the file is in an Excel Services trusted location and that you have access to the file” in Microsoft Office SharePoint Server (MOSS)

Have you encountered this error message when opening an Excel Service Report in Microsoft Office SharePoint Server (MOSS)?
“You do not have permissions to open this file on Excel Services. Make sure that the file is in an Excel Services trusted location and that you have access to the file.”

Figure 1 - Error Message From Excel Service
Figure 1 - Error Message From Excel Service

 While the error message (Figure1) suggests either it’s a trusted location/ security issue, the entry on the Application log of MOSS (Figure 2) clearly indicates that it’s a trusted location issue only.  

Figure 2 - Application Log Entry
Figure 2 - Application Log Entry

One or more of these actions will fix this error.

1. Add the document library where the excel report exists as a trusted location (very obvious).

UI Central Adminàyour SSP>>Trusted File Locations>>Add Trusted File Location
stsadm stsadm -o add-ecsfiletrustedlocation -ssp ssp-name  -location docl ib url –LocationType SharePoint-IncludeChildren True – Description desc
 
2. Set the File Access method to use Process Account.
 
UI Central Adminàyour SSP>>Excel Services Settings>>Add Trusted File Location
stsadm stsadm -o set-ecssecurity -SSP ssp-name  -FileAccessMethod UseFileAccessAccount -RequireEncryptedUserConnection False -AllowCrossDomainAccess True  -AccessModel TrustedSubsystem

3. Verify that the Process Account is correctly set-up. To view the process account navigate to Central Admin>>Shared Services Administration>>hover around your SSP and select Edit Properties from drop-down>> Scroll down the page to see the Process Accounts with access to this SSP.

4. When you have more than one Shared Service Provider (SSP) configured on the same server, make sure the web applications are associated to the correct SSP. This is because different SSP’s may have different trusted locations. Web Applications associate to the default SSP when they are initially created.  So before you create a Web Application, set the desired SSP as Default using either one of these methods. 

UI Central Admin>>Shared Services Administration>>Change Default SSP
stsadm stsadm –o setdefaultssp -title ssp-name
 
 If you have already created the Web Application, as a post installation step do a Change Association from Central Admin>>Shared Services Administration>>Change Association. (Figure 3)
Figure 3 - Change Association
Figure 3 - Change Association

BENNY AUSTIN

One thought on “Getting rid of error message “You do not have permissions to open this file on Excel Services. Make sure that the file is in an Excel Services trusted location and that you have access to the file” in Microsoft Office SharePoint Server (MOSS)

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