Description:
Error: "Access Denied. 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."
The Excel Services is properly enabled and Excel Services trusted file locations have been properly configured in SharePoint Central Admin. Your user account has access to the Office SharePoint Server 2007 document library that you are trying to publish an Excel workbook to, however, you receive an Access Denied error when attempting to publish an Excel 12 workbook to the document library.
Solution:
Open the Shared Services Admin Site
Central Admin > Application Management > Create or Configure this Farm's Shared Services > SSP > Open Shared Services Admin Site
Set the Unattended Service Account
Shared Services Admin > Excel Services Settings > Edit Excel Services Settings > External Data > Unattended Service Account
Nope, mine is still not working. Added the site to Trusted file locations, set child sites to yes.
ReplyDeleteGot the problem. Browsed online, saw your suggestion, tried it, still didnot work
Great post! I am see the programming coding and step by step execute the outputs.I am gather this coding more information. It's helpful for me my friend. Also great blog here with all of the valuable information you have.
ReplyDeleteSharepoint Training in Chennai