What you’re seeing
- A red 'Security Risk' bar reads 'Microsoft has blocked macros from running because the source of this file is untrusted'.
- There is no 'Enable Content' button anymore, even though the same file used to work.
- A spreadsheet or template emailed by a vendor, client or colleague opens but its buttons and automation do nothing.
- Files opened from a network share address or synced folder are blocked, while copies on another PC work.
Common causes
Every environment is different, but these are the causes our engineers find most often:
- Microsoft changed Office's default so VBA macros in files marked as coming from the internet are blocked rather than just warned about.
- Files downloaded from email or the web carry a 'Mark of the Web' tag that Office uses to decide the file is untrusted.
- A network share is reached by a fully qualified name or IP address, which Windows treats as an internet location instead of the local intranet.
- No trusted locations or trusted publishers are defined for the business's legitimate macro-enabled files.
- An organization-wide policy blocks macros from internet sources, applied deliberately for security.
Why it matters
Many small businesses rely on macro-driven workbooks for quoting, payroll prep, inventory or reporting, and when those macros stop, the process stops with them. The block exists because malicious macros were one of the most common ways attackers delivered ransomware, so simply turning protection off everywhere trades a productivity problem for a security one. The right outcome restores the trusted workflows while keeping macros from unknown senders blocked.
How AskTechGurus fixes it
Skip the trial and error. A certified engineer works on your actual system, finds the root cause, and fixes it properly.
Tell us what’s happening
Submit a ticket in about two minutes. Paste the error, describe what changed, and pick your tier. No charge to submit.
A certified engineer diagnoses it
A vetted, US-based systems engineer claims your ticket, usually within minutes during business hours, and investigates over a secure remote session you can watch and end at any time.
Fixed and verified with you
The engineer resolves the root cause and confirms with you that it’s working. You don’t just get a workaround, and you get a plain-English summary of what was wrong.
Pay only when it’s resolved
Fixed price from $99, invoiced only after you approve the fix. If it isn’t resolved, you don’t pay.
Frequently asked questions
Is it safe to let our macros run again?
It can be, if trust is granted only to your known files and locations rather than to every file. That keeps legitimate workbooks working while malicious attachments stay blocked.
Why did a file that worked for years suddenly stop?
The file didn't change; Office's default handling of internet-sourced macros did. Files that arrive by email or download are now treated more strictly than before.