Problems with SharePoint Excel Services
I have been implement a SharePoint 2010 server coupled with an UAG ForeFront server in order to use the Sharepoint functionality in Windows Phone 7.
With that out of the way I am now trying to create some mobile forms, to see how it would look and feel on WP7, but first I wanted to create a list based on an Excel spreadsheet but SharePoint just kept giving me this error:
“This workbook cannot be opened because it is not stored in an Excel Services Application trusted location”
Luckily after a quick search I found myself at SharepointEduTech, which had exactly the solution for my problem:
Since I am using an SSL connection to access Sharepoint through UAG, I needed to add the “https://” location on the Excel Services Application.
To change this just navigate to your Central Administration site, then select “Manage Service Applications”, find and click on “Excel Services Application” and then under “Trusted File Locations” add a new trusted file location.