Hi all,

I am recieving this error:

I have setup a trusted location to the document library where the Excel spreadsheet resides, and I still recieved the error.  I changed the location to the entire site and I still recieve the error.  I am the Sharepoint Admin, so I have full rights to all.

I am on SharePoint 2007.

 I set the location as Http://sitename/document Library name

Location type = Windows SP Services

Checked trust Children

there are no extrernal connections so I took the defaults for all other options.

Any help would be greatly appreciated.

TIA,

Joe

Hi,

I understand that when you try to open an excel file in browser, you received Access Denied error.  You can check the excel service settings in Central Administration like this :

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. Set  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

For more information, please refer to this site:

MOSS Excel Services you do not have permissions to open this file: http://developers.de/blogs/nadine_storandt/archive/2007/09/06/moss-excel-services-you-do-not-have-permissions-to-view-this-workbook.aspx

Thanks,

Entan Ming

TechNet Subscriber Support in forum

If you have any feedback on our support, please contacttnmff@microsoft.com.

Thank you for the response Entan,

In the Services on Server section there is an Excel Calculation Services and it is started, is there also supposed to be an Excel Services?  I do not see that.

The other settings were as described. 

I while back I set up another site to use Excel services.  On that site I can open any .xlsx in the site using Excel services.  I set this new trusted location the same way as the other, but I still get the error. 

Very Strange

Hi,

I understand that the issue happens only in the specific site. Have you tried with another document library in the site? Have you added alternate access mapping for the site?

Try to set the trusted location as http://servername.domainname/sitename/libraryname. Check  the permissions on the document library to see whether it inheritance from parent. Choose one of the excel files in the library and see whether you can open it in excel application.

Thanks,

Entan Ming

TechNet Subscriber Support in forum

If you have any feedback on our support, please contacttnmff@microsoft.com.

Hi, <o:p></o:p>

Just sharing my experience of error message "You do not have permissions to open this file".

I kept getting this error although I'd check all the security and all looked correct. Took a good few hours to work out that Id previously set the library where the document is stored to have "Major and Minor" versions. Only Major
versions are viewable by general access to this library. The page I'd created, has an Excel webpart to display a document in that library. I'd not saved my document as a Major version. May be an obvious thing to some people, but it took me ages to work this out. <o:p></o:p>

Having saved the document as a Major version, the page just displayed without any problem. <o:p></o:p>