Fix Excel Macros Disabled After Upgrading to Windows 10
Question details
Excel macros fail to run and display a security warning with no prompt to enable content, despite macro settings being allowed in the Trust Center.
- Product
- Microsoft Excel
- Device & OS
- Windows 10
- Scenario
- Opening existing macro-enabled workbooks after migrating the operating system from Windows 7 to Windows 10.
- Observed behavior
- Macros are disabled and trigger a continuous security warning. The 'Enable Content' button does not appear, even though VBA macros are allowed in Excel's Trust Center settings.
Before applying fixes, make sure to create a backup copy of your original Excel workbook to prevent accidental data loss or permanent VBA code deletion during the troubleshooting process.
Unblock the File and Save as an XLSM Workbook
Windows 10 may block files migrated from older systems. Unblocking the file properties and properly resaving it can restore macro functionality.
When files are moved between operating systems or downloaded, Windows 10 often applies a 'Mark of the Web' security block. This prevents macros from running, regardless of your Trust Center settings.
Right-click the affected Excel file on your computer, select 'Properties', look for a 'Security' section at the bottom of the General tab, check 'Unblock', and click 'Apply'.
Move the workbook into a folder that has been designated as a Trusted Location in Excel's Trust Center (File > Options > Trust Center > Trust Center Settings > Trusted Locations).
Open the file in Excel, click 'File' > 'Save As', and ensure the 'Save as type' dropdown is set to 'Excel Macro-Enabled Workbook (*.xlsm)'. Save it with a slightly different name.
Repair Corrupted Workbooks by Rebuilding VBA Modules
Migration can sometimes corrupt embedded VBA macros. Exporting and re-importing the code cleans up invisible corruption.
Transfer Data to a Fresh Windows 10 Workbook
Use this method if exporting modules fails. Moving your raw data and scripts to a natively created Windows 10 file circumvents legacy file issues.
Try WPS Office for Seamless Excel File Compatibility
If Microsoft Excel continues to block your macros or struggles with legacy file corruption after a Windows 10 upgrade, consider switching to WPS Office. It provides robust support for modern Excel formats, runs lightly on Windows 10, and helps you avoid frustrating legacy migration glitches.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package.
- 2. Install on Windows 10: Run the installer and follow the quick on-screen instructions to set up the software.
- 3. Open Your Workbook: Launch WPS Spreadsheet, open your macro-enabled workbook, and continue your work without legacy OS conflicts.
Frequently Asked Questions
Why do my Excel macros stop working after upgrading to Windows 10?
Upgrading to a new operating system can cause file permission changes. Windows 10 often applies a security block to legacy files or files migrated from old systems, preventing macros from running even if Excel's Trust Center is configured to allow them.
How do I fix a massive file size increase when saving as an XLSM?
A massive increase in file size usually indicates workbook corruption or invisible formatting applied to thousands of unused empty cells. You can fix this by deleting all unused rows and columns, saving the file, or transferring the data and VBA code into a completely new workbook.
Why doesn't the 'Enable Content' prompt appear for my macros?
If the prompt doesn't appear, the file might be blocked by Windows file properties, or it is stored in an untrusted network location. Right-click the file in Windows Explorer, go to Properties, check 'Unblock', and move the file to a Trusted Location defined in your Excel settings.
Can I permanently trust a folder so macros run automatically?
Yes. You can add specific folders to Excel's Trusted Locations. Go to File > Options > Trust Center > Trust Center Settings > Trusted Locations, and add the folder path. Any macro-enabled workbook opened from this folder will run without prompting for security.
