Excel Macros

A. Carter 0 Reputation points
2026-09-03T19:17:16.26+00:00

I am unable to utilize a function on an excel sheet that I downloaded from a website because it says it's blocked due to disabled macros. I have tried multiple ways of enabling macros with no success. I need to the function in order to generate a summary of the data inputted.

Microsoft 365 and Office | Excel | Other | Windows
0 comments

2 answers

Sort by: Oldest
Most helpful Newest Oldest

  1. AI answer

    2026-09-03T19:17:33.73+00:00

    If the workbook was downloaded from a website, Excel is likely blocking its VBA macros because the file has Mark of the Web.

    Try this in order:

    1. Close the workbook.
    2. In File Explorer, right-click the Excel file and select Properties.
    3. On the General tab, look for Security at the bottom.
    4. If Unblock is available, check Unblock, then select Apply and OK.
    5. Reopen the workbook.

    If Unblock is not available or the macros are still blocked:

    1. Move the file to a local folder that is trusted.
    2. In Excel, go to File > Options > Trust Center > Trust Center Settings.
    3. Select Trusted Locations.
    4. Add the folder where the workbook is stored.
    5. Reopen the workbook from that trusted location.

    If the file is on OneDrive or SharePoint:

    • Open it by using Open in Desktop App, or
    • Download it locally first and then remove Mark of the Web from the local copy by using Properties > Unblock.

    If a yellow Security Warning bar appears instead of a hard block, select Enable Content to trust that document.

    Important: only do this for files that are trusted. Microsoft notes that macros can contain malicious code, and macros are not required just to view or edit the file.

    If the workbook is on a work-managed device, organization policy can override Trust Center settings and continue blocking macros. In that case, the file location may need to be added as a trusted site or local intranet location by IT.

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

  2. Kai-H 26,135 Reputation points Microsoft External Staff Moderator
    2026-09-04T09:10:25.6066667+00:00

    Hi, A. Carter

    Since this is Excel for Windows and the usual unblock and trusted-location methods have already failed, the workbook may have been extracted from a blocked ZIP file, saved in a non-macro format, or built with older Excel 4.0 macros.

    If the workbook came inside a ZIP file, delete the extracted copy. Right-click the original ZIP file, select Properties, choose Unblock, and then extract the workbook again. The blocked status can pass from the ZIP file to everything extracted from it.

    Confirm that the workbook ends in.xlsm or.xlsb. An.xlsx file cannot store VBA macros, so download the correct macro-enabled version from the website.

    In Excel, open File > Options > Trust Center > Trust Center Settings > Macro Settings. If the workbook uses older Excel 4.0 macros, select Enable Excel 4.0 macros when VBA macros are enabled, then restart Excel.

    Ask the website owner for a newly downloaded or digitally signed copy. A trusted publisher’s signed macro can be allowed without lowering security for every workbook.

    Only proceed if the website and workbook are trustworthy.

    Thank you for your patience in reading, I hope this information has been helpful to you. 

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

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

    Was this answer helpful?

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.