TL;DR — Resumo 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 artigo foi publicado originalmente em 2013. Alguns passos, comandos ou versões de software podem ter mudado. Consulte a documentação atual de Sharepoint 2013 para as informações mais recentes.
Pré-requisitos
Antes de começar, certifique-se de ter:
- 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.