How to Fix Excel Macros Not Running in Microsoft 365 Personal
Question details
The user is unable to run Excel macros in their Microsoft 365 Personal desktop application.

- 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 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.
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.
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.
Launch Excel and go to File > Options. Select 'Trust Center' from the left pane and click the 'Trust Center Settings' button.
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.

Opt Out of the Office Insider Program
Office Insider or Beta builds often contain experimental updates that can break VBA functionality. Reverting to a stable release can resolve macro execution issues.
Test with a Fresh Blank Workbook
Corrupted workbooks or broken VBA code can prevent macros from running. Testing a simple macro in a new file isolates the problem.
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. Download the Installer: Visit the official WPS website and download the free installation package.
- 2. Install the Software: Run the downloaded installer and follow the simple on-screen instructions to set up WPS Office on your computer.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets, open your existing Excel files, and continue your work without missing a beat.

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.




