VBA & Macro Problems

How to Fix Excel Macros Not Running in Microsoft 365 Personal

Maira MehtabMaira Mehtab Oct 12, 2026 869 views

Question details

The user is unable to run Excel macros in their Microsoft 365 Personal desktop application.

How to Fix Excel Macros Not Running in Microsoft 365 Personal
Product
Microsoft Excel
Device & OS
not provided
Scenario
Attempting to execute VBA macros in an Excel workbook within a Microsoft 365 Personal environment.
Observed behavior
The macros fail to execute, potentially displaying security warnings or VBA errors, often caused by unsafe file blocks or unstable Office Insider builds.
Before you start

Before troubleshooting, ensure you completely trust the source of the Excel file, as macros can contain harmful code. Take note of any specific error messages or security ribbons that appear when you open the document.

Solution 1Recommended

Adjust Macro Security and Unblock the File

Microsoft 365 blocks macros by default for files originating from the internet or other computers. Adjusting Trust Center settings and unblocking the file allows trusted scripts to run.

Modern versions of Microsoft 365 have strict default security policies to prevent malicious scripts from executing automatically. You must explicitly unblock the file at the system level and ensure your Trust Center settings permit macro execution.

1
Unblock the file in Windows

Close Excel entirely. Locate your workbook in Windows File Explorer, right-click the file, and select 'Properties'. On the General tab, look for a Security section at the bottom and check the 'Unblock' box. Click Apply and OK.

2
Open Trust Center Settings

Launch Excel and go to File > Options. Select 'Trust Center' from the left pane and click the 'Trust Center Settings' button.

3
Configure Macro Settings

Navigate to the 'Macro Settings' tab. Select 'Disable VBA macros with notification' so you can manually approve safe macros when opening workbooks. Click OK to save.

Adjust Macro Security and Unblock the File
Security Warning: Never select 'Enable all macros' unless you are in a highly secure environment, as this makes your system vulnerable to malicious code.
Free Microsoft Office alternative

Try WPS Office for a Reliable Spreadsheet Experience

If unstable Microsoft 365 updates or strict default macro blocks are interrupting your workflow, WPS Office provides a lightweight, free, and highly stable alternative for managing your spreadsheets without forced experimental updates.

  1. 1. Download the Installer: Visit the official WPS website and download the free installation package.
  2. 2. Install the Software: Run the downloaded installer and follow the simple on-screen instructions to set up WPS Office on your computer.
  3. 3. Open Your Spreadsheets: Launch WPS Spreadsheets, open your existing Excel files, and continue your work without missing a beat.
Highly compatible with Microsoft Excel formats including .xlsx, .xls, and .csv.Stable environment that avoids forced, buggy beta updates.Free and lightweight, consuming significantly fewer system resources.Familiar user interface makes migrating from Microsoft 365 seamless.
microsoft office alternative - wps office

Frequently Asked Questions

Why did my Excel macros suddenly stop working in Microsoft 365?

Macros can suddenly stop working due to a recent Microsoft 365 update, especially if you are enrolled in the Office Insider program. Additionally, Microsoft frequently updates its security protocols to automatically block macros in files downloaded from the internet.

How do I unblock an Excel file to allow macros?

Close Excel completely, locate the file in Windows File Explorer, right-click it, and select Properties. At the bottom of the General tab, check the box that says 'Unblock', then click Apply and OK.

Does WPS Office support VBA macros?

Yes, specific versions of WPS Office offer comprehensive support for VBA macros. You can write, edit, and run scripts in WPS Spreadsheets similarly to how you would in Microsoft Excel, provided you have the appropriate VBA module installed.

How can I tell if I am using an Office Insider build?

Open Excel, click on 'File', and select 'Account'. Under your Product Information on the right side, look for a section labeled 'Microsoft 365 Insider' or 'Office Insider'. If this section is present, you are on an experimental build.