How to Open the Trust Center in Excel for Microsoft 365

How-to basics · Updated November 21, 2026

In Excel for Microsoft 365 on Windows, open the Trust Center by selecting File > Options > Trust Center > Trust Center Settings. The Trust Center Settings window contains controls for features such as macros, Protected View, trusted locations, and external content. You can open it just to review the current settings; you do not need to change anything. These steps apply to the desktop Windows version of Excel, not Excel for the web.

What You’ll Need

Before you begin, make sure you have the following:

  • Excel for Windows: Use the installed desktop app. The Trust Center is not available as the same settings window in Excel for the web.
  • A way to open Excel: You can start Excel from the Start menu or open an existing workbook. Opening a workbook is optional.
  • Permission to manage settings, if you plan to change them: Some work or school organizations use policies that prevent users from editing security options. You can still try to open the window, but some controls may be unavailable.

Step-by-Step

  1. Start the desktop version of Excel. Open Excel from the Windows Start menu, taskbar, or a workbook file. You can use a blank workbook or an existing one; the Trust Center is an application-level settings area, so you do not have to open a particular file. If you open a workbook first, save any edits before changing other settings or closing it.
  2. Open the File screen. Select File at the far left of the ribbon. Excel will switch from the worksheet to its backstage screen, which contains commands such as Open, Save, Print, and Account. If a workbook is open, this does not close it; use the back arrow near the top-left when you want to return to the sheet.
  3. Choose Options. Look near the bottom of the left-hand menu and select Options. This opens the Excel Options dialog. If the menu is narrow or the Excel window is small, you may need to scroll the backstage list to see Options. Do not choose Account or the workbook’s own Properties; neither opens the settings dialog.
  4. Select Trust Center in Excel Options. In the left-hand list of categories, click Trust Center. The main panel describes security and privacy settings. At this point, you are on the Trust Center page, but its detailed controls have not opened yet.
  5. Open Trust Center Settings. Click the Trust Center Settings button in the main panel, then wait for the separate Trust Center window to appear. This second click matters: selecting Trust Center in the category list alone does not show the individual settings. If you do not see the button, maximize the Excel Options dialog or check whether your organization has restricted access.
  6. Choose a category to review. The Trust Center Settings window has categories in a navigation list. For example, Macro Settings covers how Excel handles VBA macros; Protected View covers certain files opened in a restricted mode; and Trusted Locations manages folders Excel treats as trusted. Other categories relate to external content, add-ins, and privacy options. Select a category to view its available controls.
  7. Close the windows when finished. If you only wanted to find the Trust Center, choose Cancel in the Trust Center Settings window to leave its settings unchanged. Then choose Cancel or OK in Excel Options to return to Excel. If you deliberately changed a setting and want to keep it, choose OK in the settings window, then choose OK in Excel Options. Read any warning or confirmation before accepting a security change.

The full route, from an open workbook, is therefore File > Options > Trust Center > Trust Center Settings. In some Excel layouts the wording is shortened visually, but the Options dialog still contains a Trust Center category and a button for its settings.

Common Mistakes

Stopping after selecting Trust Center. The Trust Center category in Excel Options is a landing page, not the complete settings window. Select the separate Trust Center Settings button to see the category list and controls.

Looking for it in the ribbon or worksheet. Trust Center is not a worksheet tab or a standard ribbon command. Start from the File tab and use Options. Searching the ribbon for a security control may show unrelated commands or workbook features.

Confusing the Trust Center with a file warning. A yellow security message, a Protected View banner, or an Enable Content button appears because of a particular file or its source. Those notices are not the Trust Center itself. Opening the Trust Center lets you inspect broader application settings; it does not automatically make an individual file safe.

Changing a setting just to make a warning go away. Turning off protections or enabling all macros can expose the computer and workbook data to harmful code. A warning should not be bypassed just because the file is inconvenient to open. Confirm where the workbook came from and follow your organization’s security process before changing a control.

Tips

Review settings without editing them. If your goal is simply to locate the Trust Center, open the settings window and inspect the categories, then use Cancel. That avoids saving an accidental change. If you do make a change, note the original selection first so you can restore it if needed.

Use the category that matches the issue. A macro prompt points you toward Macro Settings, while a file opening in Protected View relates to Protected View and the file’s source. A trusted location is a folder-level exception, not a general approval for every file. Understanding which feature produced a message is safer than changing several controls at once.

Keep security protections enabled unless there is a clear reason not to. Macro controls and Protected View help reduce risks from files that contain code or come from untrusted sources. If a legitimate workbook needs a particular feature, verify its source and ask your IT administrator or the person who provided it for the approved way to use it.

Remember that Trust Center settings are usually for Excel on this computer. They are not the same as workbook-specific settings, and changing a control does not necessarily change what another person sees when opening the file. Work-managed devices may also apply policies that override a user’s selection or make some settings read-only.

Use the desktop app when you need these controls. Excel for the web can open and edit many workbooks, but it does not provide this same Trust Center window. If you need to inspect desktop security options, open the file in the installed Windows version of Excel instead.

Troubleshooting

Options is missing or hard to find: Confirm that you are in the desktop Excel application and have selected File, rather than using Excel in a browser. In the backstage menu, scroll down if needed. If the app is in a simplified or compact layout, enlarging the window can make the menu easier to read. You can also close an open dialog or workbook prompt that is covering the Excel window.

You selected Trust Center but cannot find Trust Center Settings: Check the main panel on the right side of the Excel Options dialog; the button is separate from the category name in the left pane. Maximize the dialog if the button is not visible. If it remains absent or disabled, your Office installation or organization may limit access. Check with your Microsoft 365 administrator before trying registry edits or other system-level workarounds.

The settings are greyed out or revert after you close Excel: This commonly happens on a work or school computer where an administrator manages Office security policies. Close and reopen Excel to see whether a permitted change persists, but do not attempt to bypass a managed policy. Ask your IT team which setting is controlled and whether they can approve the change for a specific business need.

You are using a Mac: The Windows Trust Center path does not apply. Excel for Mac has different menus and does not present the identical Windows Trust Center window. Depending on the Excel version, check Excel > Preferences or Excel > Settings for a Security area and the options available there. The controls and names can differ from Windows; if a specific option is missing, consult your organization’s guidance or the current Microsoft support information for Excel for Mac.

You are using Excel for the web: The web app does not include the desktop Trust Center. If the workbook is stored online, use the option to open it in the desktop app, or download it only if your organization’s rules allow that. Then follow the Windows steps above. Do not download a file from an untrusted source just to bypass an online warning.

A workbook still shows a warning after you open the Trust Center: Simply visiting the Trust Center does not remove a warning. The message may depend on the file’s origin, whether it is in Protected View, or whether it contains macros or external content. Read the message, verify the file with its sender or administrator, and use only the action approved for that file. Avoid enabling content in an unexpected attachment.

Frequently Asked Questions

Where is Trust Center in Excel?
In Excel for Microsoft 365 on Windows, select File > Options > Trust Center > Trust Center Settings. The last button opens the detailed settings window.

Do I need to open a workbook first?
No. You can start Excel and open Options from the File screen without choosing a workbook. If you already have one open, the same path works.

Is Trust Center available in Excel for the web?
Not as the same desktop settings window. Use the installed Windows app to access the Trust Center. Excel for Mac has different security settings and menus rather than the identical Windows interface.

Will opening Trust Center change my security settings?
No. Opening the window does not itself change a setting. A change is made only if you select a different control and confirm it. Use Cancel if you only meant to look around.

Why can’t I change a Trust Center setting?
Your organization may manage that setting through an administrator policy, or your Excel installation may have a restriction. Contact your IT administrator instead of trying to override the control.

Does Trust Center make a workbook safe?
No. It provides controls for Excel’s security behavior; it does not scan or certify a workbook as safe. Verify who sent the file and why it needs a feature before allowing macros, external content, or other potentially risky behavior.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.