Find the Trust Center in Excel: Windows and Mac Steps

In Excel for Microsoft 365 on Windows, open File > Options > Trust Center > Trust Center Settings. The Trust Center is where you view and manage security options for macros, Protected View, trusted locations, and other potentially risky content. Before changing a setting, make sure you know why the workbook needs it; lowering protections can expose your computer or data to unsafe files.

What You’ll Need

Excel for Microsoft 365 on Windows: The steps below use the desktop app, not Excel in a browser.
Permission to change settings: A work or school administrator may control some Trust Center options. If a setting is locked or unavailable, you may need to contact your IT team.
A specific reason for changing a setting: For example, you may need to review why a workbook’s macros are blocked. You can open the Trust Center just to inspect settings; you do not need to change anything.

Step-by-Step

Open the desktop version of Excel. Start Excel from the Windows Start menu or open an Excel workbook in the desktop app. If you are using Excel for the web in a browser, the Windows desktop Trust Center steps will not apply; see the platform notes below.
Open the File tab. Select File at the upper-left of the Excel window. This opens the Backstage view, where commands such as Open, Save, and Options appear. The File tab is different from the Home tab on the ribbon.
Choose Options. Look near the bottom of the left-hand menu and select Options. If Excel is maximized and the menu is long, you may need to scroll. Selecting Options opens the Excel Options dialog box; it does not open a workbook or change its contents.
Select Trust Center. In the list on the left side of Excel Options, choose Trust Center. This page introduces Excel’s security and privacy controls. You may see a brief explanation and a button for opening the detailed settings.
Open Trust Center Settings. Select the Trust Center Settings… button. The ellipsis indicates that another dialog box will open. You are now in the Trust Center, where the categories are listed down the left side.
Choose the category you want to inspect. Common categories include Macro Settings, Protected View, Trusted Locations, Trusted Documents, and External Content. The categories and available controls can differ by Excel build, organizational policy, and installed features. Select a category to read its options before changing anything.
Make only the necessary change, if any. For example, if a workbook downloaded from the internet opens in Protected View, first confirm that you trust its source. Do not turn off Protected View or enable all macros simply to make a warning disappear. If a setting is disabled, do not try to work around your organization’s policy.
Confirm and close the dialogs. If you changed an option, select OK in the Trust Center Settings dialog, then select OK again in Excel Options. Reopen the affected workbook if needed to check whether the change addressed the issue. If you only wanted to find the Trust Center, close the dialogs without changing a setting.

Quick path to remember: File > Options > Trust Center > Trust Center Settings. The Trust Center is not a separate ribbon tab, and you usually reach it through Excel Options.

Common Mistakes

Looking for a Trust Center button on the ribbon. In Windows desktop Excel, start from the File tab and open Options. The button is inside the Trust Center page, not on the regular ribbon.
Confusing Excel Options with Trust Center Settings. Choosing File > Options > Trust Center takes you to the overview page. You must then select Trust Center Settings… to see categories such as Macro Settings and Protected View.
Assuming the web app has the same controls. Excel for the web does not provide the Windows desktop Trust Center dialog. Opening a file in a browser and searching its menus for that dialog will not get you to the desktop settings.
Turning off a protection to remove a warning. A warning may be there because Excel cannot verify a file’s origin or because the file contains active content. Disabling a protection globally can affect other workbooks too, not just the file you are trying to open.
Trusting a folder just because it is convenient. Files in a trusted location may be treated differently from files elsewhere. A broad folder, such as Downloads or a shared drive that many people can edit, can increase risk. Use a location only if you control who can put files there and have a genuine need.
Expecting every option to be editable. Organization-managed settings can be grayed out or show that an administrator controls them. This does not necessarily mean Excel is broken; it may be a deliberate security policy.

Tips

Check the source before changing security settings. If a workbook asks you to enable content, confirm who sent it and whether you expected that file. If you are unsure, contact the sender through a separate trusted channel rather than relying on a message embedded in the workbook.
Prefer a one-file solution over a global change. When an authorized workbook is blocked, use the warning bar’s available options only after verifying the file, or ask your administrator about an approved process. Avoid lowering a setting for every workbook just to open one document.
Read each category’s description. Macro Settings govern how macro-enabled files are handled; Protected View helps limit exposure when opening certain files; External Content relates to linked data and connections. These are different controls, so changing one may not solve an issue governed by another.
Keep a note of the original setting. If you are authorized to make a temporary adjustment, record what it was and restore it when the task is done. If you do not understand the effect of an option, leave it unchanged and ask your IT administrator.
Use the current desktop app for Windows instructions. Excel updates can move or refine interface text, but in Microsoft 365 for Windows the general route remains File, Options, Trust Center, then Trust Center Settings. If you cannot find Options, make sure you are in the desktop application rather than a browser tab.

Troubleshooting

I cannot see Options. Confirm that you selected File in the desktop Excel app, not a workbook tab in a browser. In some window sizes, the Backstage menu may require scrolling. If Excel is open through a managed virtual desktop or a simplified interface, ask your support team how that installation is configured.

The Trust Center Settings button is missing or unavailable. Check that you selected Trust Center in the Excel Options list. If the button is disabled or the page looks different, your organization may have applied a policy, or your Excel installation may not expose the same options. Contact your administrator rather than trying to change Windows registry settings or use an unofficial workaround.

A setting is grayed out. This usually means the control is managed by your organization, unavailable in that edition or configuration, or restricted by policy. Note the exact setting name and any message shown, then ask your IT team whether a permitted exception exists. Do not assume that signing in with a different account will make a policy disappear.

The workbook still shows a warning after I changed a setting. The warning may be controlled by a different category, the file may have been opened before the change took effect, or the warning may be about the file’s origin rather than its macros. Close and reopen the workbook, read the full warning, and check the relevant category. Do not enable content until the file and its source are trusted.

I am on a Mac. Excel for Mac does not use the same Windows Trust Center dialog. Depending on the version, look under Excel > Preferences or Excel > Settings, then select Security for the available security controls. The Mac options are not identical to Windows Trust Center categories, so follow Mac-specific guidance for the particular feature rather than searching for the Windows button.

I am using Excel for the web. The desktop Trust Center is not available in the browser. If you need a Windows Trust Center option, open the file in the Excel desktop app, if your account and organization allow it. Some file-security behavior is controlled by Microsoft 365 or your administrator and cannot be changed from the web workbook.

Frequently Asked Questions

Where is Trust Center in Excel for Windows?
In desktop Excel, go to File > Options > Trust Center, then click Trust Center Settings…. That final button opens the detailed security categories.

Is Trust Center a separate Excel app?
No. It is a group of security settings inside the Excel Options dialog. You do not need to download or install a separate Trust Center program.

Can I open the Trust Center without changing anything?
Yes. Navigate to the settings and inspect the categories, then close the dialogs with Cancel or without saving changes. Simply viewing the settings does not alter a workbook.

Does Excel for Mac have the same Trust Center?
No. Mac Excel has security controls under Excel > Preferences or Excel > Settings, depending on the version, but it does not provide the identical Windows Trust Center interface. The names and available options can differ.

Why can I not change a Trust Center option?
Your employer or school may manage it through policy, or the option may not be available in your configuration. Ask the administrator responsible for Microsoft 365 or your computer before seeking an exception.

Should I enable all macros to open a workbook?
No. Enabling all macros can allow unsafe code to run in files you open. Verify the workbook’s source and use your organization’s approved process; if you are uncertain, leave the setting protected and ask for help.

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.