in

jetlounge

the minty fresh blog that whitens your teeth!


Syndication


You do not have permissions to open this file on Excel Services

by David Leibowitz | March 3, 2008 | Comments: 12

I received this error on a vanilla install of MOSS 2007 (Microsoft Office SharePoint Server) Enterprise with the sample BI dashboards.

To fix:

1. In SharePoint Central Administration, go to 'Manage this farm's shared services'

2. Select your shared service. (Default is SharedServices1)

3. In 'Excel Services Settings' select Edit Excel Services settings.

4. Ensure that File Access method is Process Account. Click OK.

5. Back in 'Excel Services Settings' select 'Trusted File Locations'

6. Add a new Trusted file Location:

 > URL: Specigy the report library or the entire portal

 > Location Type: Windows SharePoint Services

 > Children: Trusted

 

del.ico.us digg this technorati BlinkList Furl reddit DotNetKicks google! live Facebook Stumble Upon Yahoo!




Comments

 

samuel said:

Still getting the same problem

April 7, 2008 4:13 PM
 

Jan said:

Me 2 i'm getting the problem with the mysite:

You do not have permissions to open this file on Excel Services.

please someone help me hahaha I'm really stuck!

April 8, 2008 7:09 AM
 

Ali said:

I'm stuck too, does having SQL Server installed on a different server has something to do with it ??? because I guess it is something to do with Kerberous .. HELP

April 9, 2008 12:57 AM
 

Alex said:

I came across this same situation. I followed david's instructions and i still got the error.

I resolved this by adding 2 trusted file locations, 1 to the internal address and the second using the external path.

Works like a champ.

April 12, 2008 11:30 AM
 

Gaz said:

Same problems here, but thanks to Alex, managed to get it sorted... jut make sure that external and embedded is selected when you add your portal to the trusted sites.

April 14, 2008 5:23 AM
 

Chris said:

I'm still getting the same error - what does external path mean in Alex's link?

May 16, 2008 10:51 AM
 

Ezz said:

External means the path used to locate the sharepoint site thru a domain or DNS (exmaple: http://intranet.mycompany.com)

So you should also add this path to the trusted locations:

http://intranet.mycompany.com

Cheers :)

September 6, 2008 11:14 AM
 

Premson Baby said:

I don't know its not working if I add only the document location in the trusted list, but if I add the entire site as trusted location it works! But in a security point of view i am not sure is this the way to fix.  

May 11, 2009 11:06 AM
 

JA said:

Thanks, it helped.

July 29, 2009 8:57 AM
 

dxwell said:

It worked for me after doing an iisreset after the fix.

September 4, 2009 12:06 AM
 

Murad said:

You need to add your URLs to the trusted file location:

-> SSP -> Excel Services Trusted File Locations

e.g. if your URL is http://moss/sites/test1.aspx">http://moss/sites/test1.aspx

You would do the following under:

Address:

http://moss/sites

Location Type:

Windows SharePoint Services

Check the Trusted Children check box

Leave everything as is and now every site created under the http://moss/sites webapp should work (in other words if you created a site using the Reports remplate your sample KPIs and Dashboards should work just fine now

September 11, 2009 3:18 PM
 

Usman Shaheen said:

Thanks, it works for me

April 27, 2010 7:22 AM

Leave a Comment

(required)  
(optional)
(required)  
Add
Powered by Community Server (Non-Commercial Edition), by Telligent Systems