Mapping and Trusted Locations Fix

This article will walk you through how to resolve the following error messages in Microsoft Access or Excel:

"The active content in this file is blocked. Review your Trust Center settings or contact your IT Administrator."

"SECURITY RISK: Microsoft has blocked macros from running because the source of this file is untrusted."

Map the Drive

1. Open the Start menu
2. Open "File Explorer"
3. Scroll down on the left side until you see This PC
4. Right-click on This PC and choose "Map Network Drive..."
5. Select an unused drive letter from the drop-down menu in the "Drive:" area
6. In the "Folder:" area, enter in the drive path - choose from below depending on where your file is located:

   If the file giving you the error message is:	Copy and paste this into the "Folder" box:
   Acuity MS Access database	\\data.ucdenver.pvt\dept\som\cc\cc1
   Awards (aka Grants) MS Access database	\\data.ucdenver.pvt\dept\som\cc\cc3
   CCTO FinSType (aka Speedtypes) MS Access database	\\data.ucdenver.pvt\dept\som\cc\cc1
   CCTO DM Report Excel file/macros	\\data.ucdenver.pvt\dept\som\cc\cc1
   HCTU FinSType (aka Speedtypes) MS Access database	\\data.ucdenver.pvt\dept\som\HEMATOL\HEMATOL\HCTU
   HCTU DM Report Excel file/macros	\\data.ucdenver.pvt\dept\som\HEMATOL\HEMATOL\HCTU
   Membership MS Access database	\\data.ucdenver.pvt\dept\som\cc\cc3
   NOD MS Access database	\\data.ucdenver.pvt\dept\som\cc\cc1
   NonOncTrials (PRMS) MS Access database	\\data.ucdenver.pvt\dept\som\cc\cc1
   SPORE MS Access database	\\data.ucdenver.pvt\dept\som\cc\cc1

7. Make sure "Reconnect at logon" is checked and "Connect using different credentials" is unchecked
8. Click "Finish"

Add File Location to Trusted Locations

1. Open Excel or Access (Excel if it's the DM report/Excel file giving the error messages; MS Access if it's a database such as Acuity, Membership, etc giving the error message)
2. Go to File > Options (Options is on the far left, very bottom)
3. In the pop-up, click Trust Center (far left side of the window, bottom of the list)
4. Click "Trust Center Settings" at the bottom near middle/right
5. Click Trusted Locations on the left, 2nd from top
6. Check box for "Allow Trusted Locations on my network (not recommended)" near bottom/middle. DO NOT SKIP THIS STEP!
7. Click "Add new location" button near bottom/middle
8. Click the browse button and browse to the folder your document is in and select that folder
9. Click OK to leave the window.
   NOTE: If you get an error message saying "The remote or network path you have entered is not allowed..." -click OK on the error message and click Cancel to pop up then go back to Step 6 (must check box for this to work correctly)
10. Click OK again to leave Trusted Locations window
11. Click OK to leave Options window