Inside The Web
    Facebook Twitter Instagram
    Inside The Web
    • Office
      • Excel
      • Ms Word
      • OneDrive
      • Google Docs
      • Google Sheets
      • Google Drive
    • Email
      • Gmail
      • Outlook
      • Emal Etiquette
    • Office Etiquette
    • Productivity
    Inside The Web
    Home»Office»Excel»Fix: Microsoft has Blocked Macros from Running

    Fix: Microsoft has Blocked Macros from Running

    Kritiraj BhandariBy Kritiraj BhandariSeptember 17, 2023 Excel 3 Mins Read

    In 2022, Microsoft released an update to Excel that prevented it from running macros on files downloaded from the Internet. This was an attempt to protect its users from potential malware and hackers.

    Whenever you download a file from an untrusted source or an email attachment, such files may trigger a security risk alert. “Microsoft has blocked macros from running because the source of this file is untrusted.” 

    Microsoft has blocked macros from running error Excel

    If you try to run a macro in such files, a new error message will pop up, restricting you from running the macro code. 

    can-not-run-macro

    In this article, I have listed all the possible ways to get through this security warning and unblock macros.

    Unblock Macros From File Properties

    If you are dealing with an individual file, the easiest way to unblock macros is to remove the mark of the web. Mark of the web is a technique used by Windows to determine files that have been downloaded from the internet.

    You can unblock macros using the Excel file’s properties. Here are the steps to do so.

    Note: Make sure that the Microsoft file you have downloaded is from a trusted or known source, or else your data could be compromised.
    1. Right-click on the Excel file and click on Properties. 
      Right-click-on-Excel-File
    2. At the bottom of the General tab, put a checkmark on the Unblock checkbox.
      Put-a-check-mark-on-Unblock
    3. Click on Apply and click on OK. 
      Click-on-Apply-and-ok
    4. Now, reopen the file, and you will notice that the warning message is now gone. 
    5. Lastly, go to View > Macros > View Macros and click Run. Now, your Excel file should be able to run the macro successfully. 
      Run Macros

    Add File to a Trusted Location

    If you’re someone who has to download Excel files from the internet on a regular basis, another solution to fix this issue is by adding these files to a trusted location. This way, any files that you download to this location will not be blocked by default. 

    Here are the steps in which you can add the files to a trusted location in Excel. 

    1. Open Excel and click on File. 
    2. Click on Options. 
      Click-on-Options
    3. On the bottom left side panel, click on Trust Centre > Trust Centre Settings. 
      Go-to-Trust-Centre-Settings
    4. You can now download files to existing locations from this list.
    5. If you want to add a new location as a trusted location, click on Trusted Locations from the left pane and select Add New Location. 
      Add-new-trusted-location
    6. Go to Add a Location > Browse and choose any location you want to set as your trusted location. Then, click OK.
      Add new trusted location
    7. Make sure you have checked the box “Subfolders of this location are also trusted.”
      Check-mark-on-subfolders

    Reinstall MS Office

    Your issue should be fixed by the fixes mentioned above, but if you’re still experiencing this issue, we would recommend reinstalling MS Office Suite. Here is how you can do it. 

    1. Press the Windows key and type Control Panel.
    2. Click on the Control Panel.
      Open-control-panel
    3. Under Programs, click on Uninstall a Program. 
      Open-Uninstall-a-Program
    4. Scroll down to Microsoft Office and click on it. 
    5. Click on Uninstall, which will launch a Windows prompt, then click Yes.
      Select-microsoft-office-and-click-uninstall
    6. After uninstalling, open Microsoft Office setup from your PC and follow the prompts to install Office again.
    Excel Error Macros and VBA
    Kritiraj Bhandari

      Meet Kriti, a proficient tech writer here at Inside the Web. Driven by a passion for continuous learning and improvement, he possesses the ability to decipher complex MS Office processes and translate them into user-friendly guides. His approach of seamlessly blending technical insights in a friendly tone is what sets him apart from the masses. As technology evolves, Kriti remains committed to staying ahead of the curve. On weekends, you are likely to find him preaching life lessons to his friends at a pub.

      Related Posts

      Excel By Nisha Gurung

      How to Compare Two Columns in Excel Using VLOOKUP

      Excel By Nisha Gurung

      How to Share Excel Files with Multiple Users

      Excel By Nisha Gurung

      How to Filter Based on a List in Excel

      Add A Comment
      Table of ContentsToggle Table of ContentToggle
      • Unblock Macros From File Properties
      • Add File to a Trusted Location
      • Reinstall MS Office
      • Home
      • About Us
      • Privacy Policy
      © 2025 Inside The Web

      Type above and press Enter to search. Press Esc to cancel.