Office Settings & Configuration

How to Trust Excel Files Opened From OneNote and Enable Macros

Chanuka Geekiyanage Sep 27, 2026 869 views

Question details

The user needs to know how to mark Excel workbooks opened directly from OneNote as trusted to prevent macros from being blocked for security reasons.

How to Trust Excel Files Opened From OneNote and Enable Macros

Product: Microsoft Excel and OneNote
Device & OS: not provided
Scenario: Opening an Excel workbook that contains macros directly from a Microsoft OneNote page.
Observed behavior: The Excel file is marked as untrusted by default and macros are automatically disabled, requiring manual configuration of Trust Center settings.

Before you start

Before modifying your Trust Center settings, ensure that the Excel file opened from OneNote comes from a reliable source, as enabling macros in untrusted files can expose your system to security risks.

Solution 1Recommended

Add the File Folder to Excel's Trusted Locations

The most effective way to trust files opened from OneNote is to manually add their storage directory to Excel's Trusted Locations list.

By default, Excel may treat files launched from OneNote attachments or temporary folders as potentially unsafe. Adding the specific source folder to your Trusted Locations bypasses these macro restrictions for files you know are secure.

Open Excel Options

Launch Microsoft Excel. Click on the 'File' tab in the top-left corner of the window, and select 'Options' at the bottom of the left-hand menu.

Navigate to Trust Center Settings

In the Excel Options dialog box, click on 'Trust Center' in the left pane, then click the 'Trust Center Settings...' button on the right side.

Access Trusted Locations

Select 'Trusted Locations' from the left menu within the Trust Center window. Here you will see a list of currently trusted directories.

Add the New Location

Click the 'Add New Location' button. Browse to and select the folder where your OneNote-linked Excel workbook is physically stored.

Configure Subfolder Trust

Check the box next to 'Subfolders of this location are also trusted' if necessary, and click 'OK' to save your new security settings.

Add the File Folder to Excel's Trusted Locations

Network Storage Considerations: If your OneNote notebook or the Excel file is stored on a shared network drive, you must also check the box for 'Allow Trusted Locations on my network' in the main Trusted Locations menu before adding the path.

Solution 2

Adjust Global Macro Settings with Notification

If trusting the specific folder does not resolve the issue, you can adjust your global macro security settings to allow manual approval upon opening.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

If you frequently struggle with complex Trust Center configurations or strict security blocks in Microsoft Office, consider switching to WPS Office. It provides a lightweight, highly compatible, and user-friendly environment for managing spreadsheets without sacrificing macro functionality.

1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite.
2. Install and Open: Run the installer. Once installed, open WPS Spreadsheets.
3. Open Your Workbooks: Open your macro-enabled Excel files directly; WPS Spreadsheets will handle your files efficiently with clear, easy-to-manage security prompts.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .xlsm) for easy migration.Built-in, intuitive macro environments for VBA-enabled workbooks.Lightweight design ensures fast opening of spreadsheets from note-taking apps.Completely free to download with a familiar tabbed user interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why does OneNote automatically disable macros in attached Excel files?

When you open an Excel file directly from a OneNote attachment, it is often extracted to a temporary folder or a sync directory that Excel’s default security considers an untrusted internet or network location. This triggers Protected View and automatically blocks macros to protect your computer.

Is it safe to add folders to Excel's Trusted Locations?

Yes, but only if you have full control over the folder and trust all the files within it. Avoid adding your entire hard drive, Downloads folder, or Temp folders to Trusted Locations, as this could allow malicious scripts downloaded from the internet to run automatically.

What should I do if adding the folder to Trusted Locations doesn't work?

If macros are still disabled after adding the Trusted Location, the file itself might be blocked by Windows OS security. Right-click the actual Excel file in your File Explorer, select 'Properties', and look at the bottom of the 'General' tab. If there is a security message, check the 'Unblock' box and click 'Apply'.

Can I trust a specific document instead of the whole folder?

Excel's Trust Center does not allow you to add individual files to the Trusted Locations list. Instead, you can use the 'Trusted Documents' feature by clicking 'Enable Content' when prompted by the message bar, which remembers your choice for that specific file on your current computer.

Office App Problems