VBA & Macro Problems

Fix Excel Macros Disabled After Moving to a New Computer

Natalie Taylor Sep 29, 2026 870 views

Question details

The user is unable to run Excel macros after transferring workbooks to a newly configured computer due to security restrictions or blocked files.

How to Fix Excel Macros Disabled After Moving to a New Computer

Product: Microsoft Excel
Device & OS: Windows
Scenario: Opening existing macro-enabled Excel workbooks on a new computer setup.
Observed behavior: Macros are automatically disabled by the system, preventing automated tasks and scripts from executing without displaying clear options to enable them.

Before you start

Before modifying any security settings, ensure that you completely trust the source of the macro-enabled workbook, as malicious macros can harm your computer.

Solution 1Recommended

Adjust Trust Center Macro Settings

Modify Excel's default security behavior so it prompts you to enable macros manually instead of blocking them silently.

By default, a new installation of Microsoft Office may have strict security settings that automatically disable all macros. Changing this setting to notify you will restore your ability to run safe scripts.

Open Trust Center

Launch Microsoft Excel, click on the File tab, and select Options. In the Excel Options window, click on Trust Center in the left-hand pane, then click the Trust Center Settings button.

Modify Macro Settings

In the Trust Center window, select Macro Settings from the left menu. Choose the option labeled 'Disable all macros with notification'.

Enable Content

Click OK to save your changes and close the dialog boxes. Reopen your macro-enabled workbook; you should now see a yellow security warning bar at the top with a button to 'Enable Content'.

Best Practice: Using 'Disable all macros with notification' is the safest approach, as it prevents automatic execution while still giving you control over trusted files.

Solution 2

Unblock the File via Windows Properties

Remove the security block that Windows automatically applies to files transferred from another computer or downloaded from the internet.

Solution 3

Add a Trusted Location in Excel

Designate a specific folder on your new computer as safe, allowing all macros within it to run without prompts.

Free Microsoft Office alternative

Run Macros Smoothly with WPS Office

If organizational Group Policies or persistent activation issues are preventing you from running macros in Microsoft Excel on your new computer, consider switching to WPS Office. It provides excellent compatibility for VBA macros in a lightweight, free alternative.

1. Download and Install: Get the free version of WPS Office from the official website and install it on your new computer.
2. Open WPS Spreadsheet: Launch WPS Spreadsheet and navigate to your existing macro-enabled workbook.
3. Enable Macros: When prompted by the security warning, simply choose to enable macros and seamlessly resume your automated workflows.

Fully compatible with Microsoft Excel macro formats (.xlsm, .xlsb)Built-in VBA editor for seamless script editing and executionBypass complex Group Policy restrictions typical of enterprise Office setupsLightweight design ensuring fast installation on any new PC

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel automatically disable macros on a new PC?

A fresh installation of Microsoft Office typically defaults to high-security settings in the Trust Center. This is a protective measure designed to prevent malicious code from executing automatically without your explicit permission.

Can Office activation issues cause macros to stop working?

Yes. If Microsoft Office is not properly activated or signed into a licensed account on your new computer, the software will enter Reduced Functionality Mode. In this mode, most advanced features, including the execution and editing of VBA macros, are disabled.

What should I do if the 'Unblock' option is missing in Windows Properties?

If the 'Unblock' checkbox does not appear in the file's Properties, it means Windows has not flagged the file with the 'Mark of the Web'. If macros are still not running, the issue is likely within Excel's Trust Center settings or restricted by your organization's Group Policy.

Can my organization block me from changing macro settings?

Yes. If your new computer is managed by an IT department, they may deploy Group Policies that enforce strict macro security. These policies can grey out Trust Center options and prevent you from running or enabling macros entirely. You will need to contact your IT administrator for an exception.

Excel & Data Problems