Note : Cet article a été publié à l’origine en 2013. Certaines étapes, commandes ou versions de logiciels ont pu changer. Consultez la documentation actuelle de Sharepoint 2013 pour les informations les plus récentes.

Prérequis

Avant de commencer, assurez-vous d’avoir :

  • SharePoint Server 2013 or later
  • Farm administrator or site collection admin access
  • PowerShell with SharePoint snap-in

How to: Resolve issue “This workbook cannot be opened because it is not stored in a trusted location. To create a trusted location, contact your (http://en.wikipedia.org/wiki/System_administrator “System administrator”).” on (http://sharepoint.microsoft.com “Microsoft SharePoint”) 2013

Right after installing SharePoint 2013 you might run into the issue that when your users try to open an Excel file you run into the (http://en.wikipedia.org/wiki/Error_message “Error message”) “This workbook cannot be opened because it is not stored in a trusted location. To create a trusted location, contact your system administrator.”. This can be easily resolved by adding your Site to the list of trusted locations as indicated below:

  1. Open Central Web Administration
  2. Click on Manage Service Applications
  3. Click on (http://en.wikipedia.org/wiki/Excel_Services “Excel Services”) Application.
  4. Click on “Trusted file locations”
  5. Add your trusted location. You could easily just have http or https so that it accepts almost any site… I would just add my trusted sites (internal sites) to be safe.

(http://img.zemanta.com/zemified_h.png?x-id=02eea99c-3b02-4712-83e9-7bed217d63ae)](http://www.zemanta.com/?px “Enhanced by Zemanta”)

Résumé