Unblock macros that Microsoft has blocked because source of the file is untrusted

Rachel Mayo (Mayo Rachel) 20 Reputation points
2026-08-11T11:57:18.0966667+00:00

Hello, I have opened my personal daily file to have the message "Security Risk Microsoft has blocked macros from running because the source of this file is untrusted". I have checked the properties of the file and there is no area or option to click unblock. I have went into Options - Trust Center - Trust Center Settings and added the file location to the list. I have also went into Options - Trust Center - Trust Center Settings - Marco Settings and enabled VBA but still no luck being able to use my macros.

Microsoft 365 and Office | Excel | For business | Windows
0 comments
Answer accepted by question author
Roebe Ta 265 Reputation points Independent Advisor
2026-08-11T14:56:35.52+00:00

Thanks for your update @Rachel Mayo (Mayo Rachel).

As this file is stored in a local folder, you may want to try adding that folder as a Trusted Location in Excel:

  • Open the Excel file.  
  • Navigate to Trust Center Settings: File > Options > Trust Center > Trust Center Settings  
  • Go to Trusted Locations. If you see Disable all Trusted location is checked, please uncheck it. 
  • Click Add new location > Click Browse to find the folder, select a folder, and then click OK. 

User's image

  • If the issue persists: In the same Trusted Locations settings, click Add new location, then enter the following path in the text box that appears: 
    • For personal account: https://d.docs.live.net   
    • For business account: Go to File > Scroll down to find the file you've just opened > Right click and choose Open file location > Copy the file address to put in the text box.  

User's image

  • Click the checkbox "Subfolders of this location are also trusted"  
  • Click Ok and Restart excel.  

Note: This will trust macros in all files stored in your folder. For security, I recommend only saving and opening files from sources you trust.  

Please let me know the result after trying these steps, and I'll be happy to assist further if needed.

Thank you for your time!

Was this answer helpful?

2 people found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rachel Mayo (Mayo Rachel) 20 Reputation points
    2026-08-11T12:27:14.72+00:00

    Microsoft 365 Apps for enterprise; Version 2607.

    This file was created on this computer, not downloaded, and opened from a local folder.

    Windows 11 Pro

    User's imageUser's image

    User's image

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Roebe Ta 265 Reputation points Independent Advisor
    2026-08-11T12:18:02.3933333+00:00

    Hello @Rachel Mayo (Mayo Rachel),

    Before providing the accurate solution, please confirm these additional information:  

    • What is your Excel version (Microsoft 365 subscription or other version) ?  
    • As this question is under the Windows tag, can you help confirm if you're using Excel for Windows device? If not, what is your operating system? 
    • Did you download this file to your local device or use it directly from the OneDrive/SharePoint folder or local folder? 
    • If this is a downloaded file, can you tell us the source of the download (for example, email, OneDrive, SharePoint, or a website)?
    • Can you share some detailed screenshots of this issue? Including this information:  
      • The error message you received when using this file.  
      • The properties of the file where you cannot see the option to click Unblock.
      • Go to File > Options > Trust Center > Trust Center Settings... and screenshot your Macro Settings, Trusted Documents, Trusted Locations.  

    Please remove any personal information before uploading images on this public forum. Your additional information will much help finding the root cause of your issue. I appreciate your effort that help provide the accurate solution.  

    Meanwhile, if this file originated from an online source, the article below may help resolve the issue: Macros from the internet are blocked by default in Office - Microsoft 365 Apps | Microsoft Learn

    Looking forward to your response so we can get this sorted out for you together. 

    If the answer is helpful, please click "Yes". If you have extra questions about this answer, please click "Comment".    

    Note: Please follow the steps in the forum documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.