Add SharePoint site to trusted locations in Excel

Inhaltsverzeichnis Show

Related Posts
Obtain address details of the SharePoint site or library you wish to map
Add the SharePoint site to Internet Explorer's Trusted Sites
Use the Map Network Drive wizard, to map the site as a network drive

Check out the new look and enjoy easier access to your favorite features

Our company has a bunch of different office templates for various customer work, and a few of them have macros. Originally I set this up by using a dfs share and Group Policy to point to the share, and set the share as a Trusted Location and everything works fine.

Now because of the amount of remote people and our recent move to Office365 I thought why not use sharepoint. So I basically copied the GPO and changed the workgroup templates to point to the file path on the machine that the sharepoint document library would sync to when you sync it to a users PC.

For some god awful reason Word still disables the macros on the file and the user gets the banner asking to enable them, but before when opening them from the share they did not have this problem. Even if I copy the file out of the synced sharepoint library to another location that I have defined as a trusted location its fine. So it seems to be something specific to the sharepoint library despite it sittin in c:\users%username%\Orgname\

I've tried adding the sharepoint site to the trusted sites in internet options but that also didnt effect it. Really not sure what else to try. Googling anything about word and macros just gives you generic garbage.

Edit:

I just tried another test where I disabled the network on my test machine and opened those documents and I dont get the banner. This means it must be opening it/treating it slightly different when it can talk to sharepoint online.

I dont know if theres a way to check the "directory" that word thinks its opened it from to see if there is a hidden "file path" that I can white list some how.

Edit2:

Ok so it turns out this was a rather simple fix, but doesn't seem to be documented all that well (at least from what I could see), but basically you can put in the actual sharepoint online url in to the trusted locations in the office settings.

SharePoint Diary » SharePoint » Fix “This workbook cannot be opened because it is not stored in an excel services application trusted location” Error in SharePoint 2010

Problem: Got this error when trying to open an Excel Sheet stored in a SharePoint 2010 document library: “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”.

Solution:

By default, Excel Services allows browser rendering on Workbooks in “Trusted location”. Add your SharePoint library/site/webapp URL to Excel services trusted file location to eliminate this issue. Here is how to create excel services trusted location:

Navigate to SharePoint 2010 Central Administration site
Under Application Management, Click on Manage Service applications
Select “Excel Services Application” and click on “Manage”
Click on “Trusted File Locations” and then Click on “Add Trusted File Location”
Enter the URL of your SharePoint web app/site/library and choose “Trust Children”
Click “OK” to save your configuration changes.

Now, your Excel sheet should render without any issue.

Technet Reference: Manage Excel Services trusted location – https://technet.microsoft.com/en-us/library/ff191194.aspx. It’s also possible to manage trusted locations using PowerShell. Here is the reference: Excel Services cmdlets

Salaudeen Rajack – SharePoint Architect. Primarily on Infrastructure, Operations, Administration and Architecture!

Want to contribute?
Are you a SharePoint expert? Well, You can start contributing to this site! Find out now: How to Contribute and What you’ll get in return?

When you open a MS Office document from you cloud hosted server, you may see the option to ‘Enable Editing’ at the top of the page each time. The cause is because your cloud hosted server is not a ‘Trusted Location’ in Office 365. To add your cloud server as a trusted location, follow these steps:

1. Open Office 365 (Word or Excel)

2. Click File > Options.

3. Click Trust Center > Trust Center Settings > Trusted Locations.

4. Click Add new location.

5. Click Browse to find the folder, select a folder, and then click OK.

SharePoint Online is a cloud-based service provided as part of the Office 365 suite. It allows users to organise and share information and collaborate with colleagues, partners and customers.

Many organisations using SharePoint have document libraries mapped as network drives, so enabling users to connect to a shared SharePoint library on the network.

This article shows how to map a SharePoint site, or library, to a network drive letter on your PC. There are three steps:

Obtain address details of the SharePoint site or library you wish to map

To map a SharePoint site as a network drive, you first need to obtain the address details of the SharePoint site or library you wish to map. Proceed as follows.

Note:
It's important to use Internet Explorer, as this won't work in other browsers, not even the new Windows 10 browser, Edge. In Windows 10 you'll need to search for IE by hitting the Windows key and typing in "Internet Explorer".

Enter name and password, tick the Keep me signed in check box, then click Sign in.

Navigate to the SharePoint site or library you wish to map to. For example, in this article we will use the Professional Services Shared Documents site.

The SharePoint address details are shown in the address box at the top of the display. You will need to return to this point for these details during the next two steps of this procedure.

Add the SharePoint site to Internet Explorer's Trusted Sites

Add the site to Internet Explorer's Trusted Sites as follows.

From Internet Explorer, click the Settings icon in the top right hand corner of the Window and, from the dropdown menu, click Internet options.

Note:
Depending on your version of Internet Explorer you may access Internet options from the Tools menu, or from the Control Panel.

The Internet Options pages appears.

Click on the Security tab, then click Trusted sites.

The Trusted sites dialogue box appears.

In the Add this website to the zone, text box, enter the ROOT site (for example, https://backupdirect.sharepoint.com) of the library you want to map.

Note:
Entering the ROOT site onto the Trusted sites list, prevents having to add individual trusted sites if connecting mapped drives to more than one library in the site.

Use the Map Network Drive wizard, to map the site as a network drive

Before starting the Map Network Drive wizard, briefly return to SharePoint and copy the full address of the document library that is to be mapped.

Keep this on your clipboard for Step 2 of the following procedure.

To access the Map Network Drive wizard, proceed as follows.

Open File Explorer, and click Map network drive.

Note:
When you click Map network drive, you may be prompted with another dropdown menu. If so, then from the dropdown options, click Map network drive.

The Map Network Drive wizard opens.

In the Folder text box, paste the full address of the SharePoint library that is to be mapped. Then, if necessary, remove any lower level sections of the address as highlighted below.
Tick the Connect using different credentials checkbox.
Click Finish.

A Windows Security dialogue box appears.

Enter your Office 365 login credentials, and click OK.

Your SharePoint site is now mapped as a network drive, and may be viewed through File Explorer.

Want to talk to an Office 365 expert?

Our team are always here to help you make the most of your online office.
Not a customer of ours? Get in contact today to find out how we can support you.