Excel’s security warning for macros and external links may stop appearing on your computer. This happens when you permanently trust a document, and Excel adds it to a hidden list. The application will no longer ask for permission to open that specific file. This article explains why the warning disappears and provides steps to reset your trusted documents list.
Key Takeaways: Restoring Excel Security Warnings
- Trust Center > Trusted Documents > Clear: Removes all files from the trusted list, forcing security prompts to reappear.
- Windows Registry Editor: Manually delete the trusted documents registry key if the Excel setting fails.
- File > Options > Trust Center > Trust Center Settings: The main menu path to manage security warnings and trusted locations.
Why Excel Security Warnings Stop Appearing
Excel uses a feature called Trusted Documents to remember your security decisions. When you open a file with active content like macros or external links, a yellow Security Warning bar appears. If you click “Enable Content” and check the box for “Trust all documents from this publisher,” Excel adds the file to a trusted list. For files without digital signatures, clicking “Enable Content” and selecting “Enable All Content” can also add the file as trusted. Once a document is trusted, Excel opens it without any security prompts on all future launches. This setting is stored per user on the Windows computer.
The trusted documents list is separate from the Trusted Locations list. Trusted Locations are folders where any file is considered safe. Trusted Documents are specific file paths that you have individually approved. The list is stored in the Windows Registry, not within the Excel file itself. If the warning no longer appears for a file you now consider risky, you need to clear this cached trust data.
Steps to Reset the Trusted Documents List in Excel
The primary method to restore security warnings is through Excel’s Trust Center. This process clears the trust status for all previously approved workbooks.
- Open Excel Trust Center Settings
Launch Excel and go to File > Options. In the Excel Options dialog, select Trust Center from the left sidebar. Then, click the “Trust Center Settings…” button on the right. - Navigate to Trusted Documents
In the Trust Center window, select “Trusted Documents” from the list on the left. This panel shows options related to files you have enabled in the past. - Clear All Trusted Documents
Click the “Clear” button next to the text “Clear all trusted documents so that Excel prompts about them again.” A confirmation dialog will appear. Click “Yes” to proceed. Close all open Excel windows by clicking OK on the open dialogs. - Restart Excel and Test
Completely close and restart Excel. Open a file that previously contained macros or external links without prompting. The yellow Security Warning bar should now be visible at the top of the window, below the ribbon.
Manual Registry Edit Method
If the Clear button in Excel is grayed out or does not work, you can edit the Windows Registry. Warning: Editing the registry incorrectly can cause system problems. Back up the registry first.
- Open the Registry Editor
Press Windows key + R, type “regedit”, and press Enter. If prompted by User Account Control, click Yes. - Navigate to the Trusted Documents Key
In the Registry Editor, go to this path: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Security\Trusted Documents. The “16.0” corresponds to Microsoft 365 and Office 2021/2019. For older versions, use 15.0 for Office 2013 or 14.0 for Office 2010. - Delete the TrustRecords Values
In the right pane, you will see values named like “TrustRecords”. Right-click on the “TrustRecords” value name and select Delete. Confirm the deletion. Do not delete the entire “Trusted Documents” folder key on the left. - Close Registry Editor and Restart
Close the Registry Editor and restart your computer. When you open Excel again, the trusted documents list will be empty.
If Security Warnings Still Do Not Appear
After resetting trusted documents, warnings should return. If they do not, other settings may be blocking them.
Macro Settings Are Disabling All Warnings
Check the macro security level. Go to File > Options > Trust Center > Trust Center Settings > Macro Settings. If “Disable all macros without notification” is selected, no warnings will show. Choose “Disable all macros with notification” to see the yellow warning bar.
File is in a Trusted Location
Excel does not check files stored in Trusted Locations. Go to Trust Center > Trusted Locations. If the file’s folder is listed there, move the file to a different directory like your Desktop and open it from there to trigger the security check.
Windows Group Policy Overrides User Settings
In a corporate network, system administrators can use Group Policy to disable security warnings for all users. The local Excel settings will not override this. Contact your IT department to check if a policy is applied.
Trusted Documents vs. Other Security Prompts
| Item | Trusted Documents | Trusted Locations | Macro Security Level |
|---|---|---|---|
| What it controls | Trust for specific individual files | Trust for all files in a designated folder | Global rule for all macros in any file |
| Effect on warnings | Disables prompts for the trusted file only | Disables all security checks for files in that folder | Can disable all macro warnings globally |
| How to reset | Clear button in Trust Center or delete registry key | Remove the folder path from the Trusted Locations list | Change the setting in Trust Center > Macro Settings |
| Storage method | Windows Registry per user | Windows Registry per user | Excel configuration file |
You can now control when Excel shows security warnings by managing your trusted documents list. Use the Clear function in the Trust Center for a quick reset. For persistent files that should always be trusted, consider moving them to a dedicated Trusted Location instead. An advanced tip is to press Alt+F+T to open the Trust Center directly from any Excel window.