This workbook cannot be opened because it is not stored in an Excel Services Application trusted location – SharePoint 2010
One of my colleagues sent me an email saying that he is getting this error (see below) whenever he tried to open an excel workbook. I just clicked the same file in the same location and I am able to open it.
![1](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_s7Ni34QUzl8iXZicik0ytXb-UVjW7eGFYRHYtLrJlgLkrPigEJxPUu3Hv4I9Hf5YxBuX4ECv7upZyN-b8sezctZ-7OLYxhsyiFMgXRiXLueOwBER9fz2gqQ3HPbeI=s0-d)
But when I click on the excel file drop down –> View in Browser then I also got the same error.
![2](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_utg6A0qrBWH2cnketLaK-nsZfm5-Bw8Uew4_udemWL_mstTuu6os03azFAEl1UtDdl8tw3MrjjnbcPeg2gk2ZROvi71O-IgDEhh4YxaHyGpUgKuj9zRoDM3bfrIQ=s0-d)
The text format of the error is:
According to the error message, obviously we need to add the document library path to Trusted File Locations in the Central Administration. So we will see the steps here.
Step 1: Go to Central Administration –> Manage service applications under Application Management
![3](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_tkoLsVNvkcbHim_aSH2McVKGwRuKjn4RFZI0Ea27O9AkZpRu-jcfk2oGZD020HEPQsuAVRsPJr7c_ohneG2FT5HChe2W15SoSjihtFFRPco9tRF11VM5T3NcmOtwIWzrWkP0c=s0-d)
Step 2: Then click on the Excel Services Application
![4](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_ugNrvmCuntOH_TNTLvzke-PTN-RKCmXPlK6Is6Z2frXgbMqITcJTifohw4K8RDBuF9uwS_MYGJlrpLj8OAIjwQq133OckkUM0eV4cd09NItsm1THq8bCe0JBiw2StL0UsH1NM=s0-d)
Step 3: Click on the Trusted File Locations
![5](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_vLkR6UaENAnn-Xid3xhhe4MvxyoA71iqH_3S5fbrcJx8bZOhrsRJZahO_Q5BV23_bRmhQtEI4A3xGh8QmawifwN9htpy28DGZQA4kA_9udhwA_IMLw7x50tWqyApeQQl34eA=s0-d)
Step 4: Just click Add Trusted File Location under Excel Services Application
![6](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_tJSFoSEX3BslkbSPKrmM1q4Oef_IaoWdRe2YEtZ-MunEjmUAE886UVKqVAFrdwUob4zNcvtD2KouLCcw4yaaK0NNbG438e6gON8VlFhPrDkhDSRr9OVOT0j3QB3EQmwxr9eS8=s0-d)
Step 5: Add the document library url (OR file location) on the Address box and check the Children trusted check box –> Click ok
Please note: Don’t use like http://server:1010/documentlibrary1/forms/default.aspx instead of http://server:1010/documentlibrary1
![7](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_s4mljWldxRMbcbGtD6xrhdEmAtg38LTW4le9_qQZnweaQcVMZVaigeYrkcUGFyQyMBmLR1_KL4WGWrERBisORCL1sNChNTSNFXjQOfB5hU7BqUzvdOYCLDPn297g=s0-d)
If you use SSL (Secure Sockets Layer)/HTTPS connections, just add https:// on the address.
But when I click on the excel file drop down –> View in Browser then I also got the same error.
The text format of the error is:
1
2
3
| This workbook cannot be opened because it is not stored in an Excel Services Application trusted location. To create an Excel Services Application trusted location, contact your system administrator. |
Step 1: Go to Central Administration –> Manage service applications under Application Management
Step 2: Then click on the Excel Services Application
Step 3: Click on the Trusted File Locations
Step 4: Just click Add Trusted File Location under Excel Services Application
Step 5: Add the document library url (OR file location) on the Address box and check the Children trusted check box –> Click ok
Please note: Don’t use like http://server:1010/documentlibrary1/forms/default.aspx instead of http://server:1010/documentlibrary1
If you use SSL (Secure Sockets Layer)/HTTPS connections, just add https:// on the address.
No comments:
Post a Comment