You may see a banner in Excel like this

 

This banner began to appear in June 2022 after Microsoft updated its Macro policies to reduce security risks. In response, DNS altered our policies so to allow these macros to run if they are located on the Google Drive (G:\). Note: you will likely see the red banner if you place a file on your local computer. 


Two suggestions:

  1. Move your file to the Google Drive shared folder. That should be the solution 100% of the time.
  2. If that doesn't work, follow these steps
    1. Open Windows File Explorer and go to the folder where you saved the file.
    2. Right-click the file and choose Properties from the context menu.
    3. At the bottom of the General tab select the Unblock checkbox and select OK.


      In file properties, near the bottom of the General tab, is a Security section with a checkbox for unblocking the file.