Macro enables files from Network Share fix

This article is to show you how to fix macro-enabled documents or spreadsheets not working when opened from a network share.

  1. Open your file and click here:
    Uploaded Image (Thumbnail)
     
  2. If you click the link it should take you to a website. If not, you go use this link:  https://support.microsoft.com/en-us/topic/a-potentially-dangerous-macro-has-been-blocked-0952faa0-37e7-4316-b61d-5b5ed6024216
     
  3. Scroll down until you see the following set of instructions: 

    Uploaded Image (Thumbnail)
     
  4. Go to Start and type Internet Options as shown below:

    Uploaded Image (Thumbnail)
     
  5. Once you open Internet Options you should see the following page and select the Security tab as shown below:

    Uploaded Image (Thumbnail)
     
  6. You will select Trusted Sites and then select Sites as shown below:

    Uploaded Image (Thumbnail)
     
  7. From here you will enter in your network share path as shown below then select Add

    Uploaded Image (Thumbnail)
     
  8. Select Ok and then go back and open your file from the network share. It should open without an error below the ribbon

    Uploaded Image (Thumbnail)
     

Please reach out to the Service Desk if you have any questions.