HTTP 403 Forbidden when calling Excel Services REST API (ExcelRest.aspx)

Today I was looking into Excel Services REST API (ExcelRest.aspx) in SharePoint 2010 for the first time. I followed some good articles on the web but kept on getting HTTP 403 Forbidden errors when invoking ExcelRest.aspx through the browser. Surprisingly didn’t find much help on this error on Google.

Looked into the ULS and found the following error message:

Result=Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceBase+EcsFaultException: This workbook cannot be opened because it is not stored in an Excel Services Application trusted location. (Fault Detail is equal to Microsoft.Office.Excel.Server.ExcelServerMessage).

This must be one of those rare occassions that SP gives you error messages that help troubleshooting!

To fix this launch Central Admin, then go to Manage service applications, and click on Excel Services Application. Click Trusted File Locations and then add your location as a Trusted File Location.

Advertisements

About Bernado

Based in Australia, I am a freelance SharePoint and Dynamics CRM developer. I love developing innovative solutions that address business and everyday problems. Feel free to contact me if you think I can help you with your SharePoint or CRM implementation.
This entry was posted in Excel Services, SharePoint 2010. Bookmark the permalink.

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