VBA & Macro Problems

How to Fix Word Blocking Macros in an Embedded Excel File

Maira Mehtab Sep 22, 2026 869 views

Question details

The user is experiencing an issue where Microsoft Word blocks VBA macros from running inside an embedded Excel workbook.

Product: Microsoft Word, Microsoft Excel
Device & OS: not provided
Scenario: Attempting to execute VBA macros from an Excel workbook that has been embedded into a Microsoft Word document.
Observed behavior: Macros are actively blocked by recent Microsoft Office security changes affecting embedded content, even when files are stored locally and macro settings are theoretically enabled.

Before you start

Ensure you are using the latest version of Microsoft Office, and verify that your macro settings in the Trust Center are explicitly set to allow execution for testing purposes.

Solution 1Recommended

Unblock Files and Configure Trusted Locations

Resolve macro blocking by ensuring the source Excel file and the Word document are trusted and explicitly unblocked in Windows file properties.

Recent Microsoft Office security updates apply the 'Mark of the Web' (MOTW) to files downloaded from external sources. This feature actively blocks macros in embedded files unless they are saved in a Trusted Location or manually unblocked.

Unblock File Properties

Right-click the source Excel (.xlsm) and Word files in Windows File Explorer and select 'Properties'. In the 'General' tab, look for a 'Security' section at the bottom. If you see an 'Unblock' checkbox, check it and click 'Apply'.

Access Word Trust Center

Open Microsoft Word and navigate to 'File' > 'Options' > 'Trust Center', then click the 'Trust Center Settings' button.

Add Trusted Location

Select 'Trusted Locations' from the left menu. Click 'Add new location', browse to the local folder containing your files, check 'Subfolders of this location are also trusted', and click 'OK'.

Apply to Both Applications: You may need to repeat the Trusted Locations setup in Microsoft Excel's Trust Center to ensure both applications authorize the embedded macro content.

Solution 2

Provide Sanitized Files to Microsoft Support

If local security settings and unblocking do not resolve the issue, the files may require deep investigation by the Microsoft Support team.

Free Microsoft Office alternative

Experience Hassle-Free Document Management with WPS Office

If strict Microsoft Office macro security updates are disrupting your embedded workflow, consider trying WPS Office. It provides a lightweight, highly compatible environment for your Word and Excel needs without the convoluted setup process.

1. Install WPS Office: Download and install WPS Office free of charge on your device.
2. Open Your Files: Launch WPS Writer or WPS Spreadsheet and simply click 'Open' to select your existing macro-enabled Word or Excel files.
3. Resume Work Seamlessly: Continue editing your embedded documents and spreadsheets with perfect layout retention and formatting support.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx/.xlsm) formats.Seamless handling of embedded objects and cross-document integration.Lightweight design ensuring fast installation and quick file loading.Familiar user interface requiring zero learning curve for standard Office users.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Microsoft Office block macros in files stored locally?

Recent Office updates use the 'Mark of the Web' (MOTW) feature to identify files originally downloaded from the internet or received via email. Even if moved to a local drive, the file retains this mark and Office automatically blocks its macros for security unless explicitly unblocked.

How do I add a Trusted Location in Microsoft Word?

Go to File > Options > Trust Center > Trust Center Settings > Trusted Locations. Click 'Add new location', browse to the specific folder on your drive, and check the box that allows subfolders to be trusted if necessary.

What is a macro-enabled Excel file?

A macro-enabled Excel file is a workbook saved with the .xlsm extension that contains Visual Basic for Applications (VBA) code. This code automates repetitive tasks but requires specialized security permissions to run.

Excel & Data Problems