Excel Fix: SECURITY RISK Microsoft has blocked macros from running because the source of this file is untrusted.

When you try to open and work on a Microsoft Office Excel Sheet on your Windows/Mac device and you see the error "Microsoft has blocked macros from running because the source of this file is untrusted." well this be because

If an Excel (xlsx or xls) or other office files you download from the internet that has VBA macros in them, there is a potential that it may contain a malicious script that can gain access to your device and deploy malware and ransomware. Thus Microsoft has changed the default behavior of Office applications to block macros in files from the internet.

How to unblock files with VBA Macros

1. Open the file in Office App (Excel/Word/PowerPoint)
2. Now go to General tab -> Properties.
3. Now select the Unblock checkbox.

Note: You can also make use of the PowerShell CMDLet Unblock-File

Example:

PS Unblock-File -Path C:\Users\Code2care\Documents\Downloads\ExcelSpreadSheet.xlsx