TL;DR — Resumen Rápido
Learn resolve issue . How to: Resolve issue This workbook cannot be opened because it is not stored in a trusted location.This workbook cannot be opened...
Nota: Este artículo fue publicado originalmente en 2013. Algunos pasos, comandos o versiones de software pueden haber cambiado. Consulta la documentación actual de Sharepoint 2013 para la información más reciente.
Requisitos Previos
Antes de comenzar, asegúrate de tener:
- 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 (https://en.wikipedia.org/wiki/System_administrator “System administrator”).” on (https://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 (https://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:
- Open Central Web Administration
- Click on Manage Service Applications
- Click on (https://en.wikipedia.org/wiki/Excel_Services “Excel Services”) Application.
- Click on “Trusted file locations”
- 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.