Macros being blocked in Excel even though file is located in trusted site

Copper Contributor

I am experiencing an issue that I have seen several discussions about, however there does not appear to be an answer so I wanted to see if anyone has found an answer for this.

 

I have a user that is getting the following message in excel when opening a file on a network share:

 

Microsoft has blocked macros from running because the source of this file is untrusted.  

 

I have confirmed that the file location is in the Trusted Center and in addition, this issue just started happening recently with no changes that I am aware of.  I have also placed the server IP and Server name of the server in the Trusted sites under Internet Options, but this did not change the issue.

 

Here is some info about the system:

 

Windows 10 Pro 10.0.19045 Build 19045

Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20124) 64-bit

 

TAMBROSY_0-1712271414566.png

 

1 Reply

@TAMBROSY 

If macros are being blocked in Excel even though the file is located in a trusted site and you've confirmed the file location is in the Trusted Center, there are a few potential reasons for this behavior. Here are some troubleshooting steps you can try:

  1. Check Macro Settings: Verify that macro settings in Excel are configured to allow macros. To do this, go to File > Options > Trust Center > Trust Center Settings > Macro Settings. Ensure that the setting is not set to "Disable all macros without notification". You can choose "Enable all macros" or "Disable all macros with notification" depending on your security preferences.
  2. Check File Format: Ensure that the file extension is one of the allowed macro-enabled formats, such as .xlsm (for Excel macro-enabled workbook). If the file extension is not recognized as a macro-enabled format, Excel may block macros from running.
  3. Verify Trust Center Settings: Double-check the Trusted Locations settings in the Trust Center to ensure that the network share location is listed correctly and enabled. Also, ensure that the "Allow trusted locations on my network" option is checked.
  4. Clear Trusted Locations Cache: Sometimes, Excel may cache the trusted locations list. Try clearing the Trusted Locations cache by removing all trusted locations and then re-adding them.
  5. Group Policy or Registry Settings: Check if there are any Group Policy settings or registry entries that might be overriding the Trusted Locations settings or macro settings in Excel. Ensure that there are no policies restricting macro execution.
  6. Test on a Different Computer: If possible, try opening the file on a different computer to see if the issue persists. This can help determine if the problem is specific to the user's computer or if it's a broader issue.
  7. Update Office: Ensure that Office and Windows 10 are fully up to date. Sometimes, issues with macro security can be resolved by installing the latest updates and patches.
  8. Antivirus or Security Software: Check if any antivirus or security software on the user's computer is blocking macro execution. Temporarily disable the antivirus software (if safe to do so) and see if the issue persists.

If none of the above steps resolve the issue, it may be necessary to further investigate the specific circumstances of the problem. The text was created with the help of AI.

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

 

Was the answer useful? Mark as best response and like it!

This will help all forum participants.