In Excel for Microsoft 365 on Windows, open the Trust Center by selecting File > Options > Trust Center > Trust Center Settings. The Trust Center is already part of desktop Excel; there is no separate switch to turn it on. Use its settings to manage macros, trusted locations, and Protected View, and change only what you need because some options reduce security.
Before changing a setting, consider what prompted the change. If Excel has blocked a file from an unfamiliar sender, that warning may be protecting your computer. Often the safer answer is to verify the file or ask its sender for a clean copy, rather than disabling a safeguard for all workbooks.
What You’ll Need
- The Windows desktop version of Excel for Microsoft 365. The steps below apply to the desktop app, not Excel for the web.
- Permission to change Excel settings. A work or school administrator may manage some options and prevent users from changing them.
- If you plan to add a trusted location, a folder you control and can keep free of untrusted files. Do not choose a broad folder such as Downloads or an entire shared drive.
- A specific reason for adjusting a protection setting, such as needing to run a macro in a verified workbook. You do not need to enable macros just to open the Trust Center.
Step-by-Step
- Open the Excel desktop app. Start Excel from the Windows Start menu or open a workbook in the desktop version. If a workbook opens in a browser, choose the option to open it in the desktop app if available. Excel for the web does not provide the same Trust Center settings.
- Open Excel Options. Select File in the upper-left corner, then select Options near the bottom of the left-hand menu. If the workbook is in a simplified view, return to the full Excel window first. The Options dialog is where desktop Excel keeps its application-level preferences.
- Go to the Trust Center. In the Excel Options dialog, select Trust Center in the left-hand list. This page explains that the Trust Center helps protect your computer and includes a button for its detailed controls. Selecting this category does not change any security setting by itself.
- Open Trust Center Settings. Select the Trust Center Settings button. A second dialog opens with categories down the left side, such as Trusted Locations, Macro Settings, and Protected View. This is the control panel most people mean when they ask how to enable or access the Trust Center.
- Choose the setting that matches your task. For example, to review why downloaded files open cautiously, select Protected View. To inspect macro behavior, select Macro Settings. To manage folders Excel treats as trusted, select Trusted Locations. Read the description for the selected category before changing an option.
- Make the smallest necessary change. If you need to run a VBA macro in a verified workbook, the safer general approach is to keep macros disabled with notification, then enable content only for a file you trust when Excel presents the warning. Avoid selecting Enable VBA macros as a general setting: it can allow macros in workbooks without a useful warning. If the task requires a trusted folder, add only that specific folder and check its contents first.
- Apply the change and return to Excel. Select OK to close Trust Center Settings, then select OK again to close Excel Options. Some changes take effect for files opened afterward, so close and reopen the relevant workbook if the behavior does not change immediately. Save your work before closing a workbook.
- Check the result without weakening other protections. Reopen the verified workbook or repeat the task that required the change. If Excel still displays a security message, read the wording carefully: a message about Protected View, macros, external data, or an administrator policy can have a different cause. Restore any temporary setting you no longer need.
What the main settings do
Macro Settings control how Excel handles VBA macros. Macros can automate useful tasks, but they can also run harmful code. Keeping notifications enabled lets you make a decision about an individual file instead of allowing every macro automatically. A digitally signed macro from a publisher you recognize may be handled differently from an unsigned macro, but a signature is not a reason to skip verification.
Trusted Locations are folders whose files Excel treats as trusted, subject to the applicable settings. This can be convenient for a controlled folder containing approved templates or internal tools. It also means files placed in that folder may receive fewer warnings. Do not use a location where email attachments or downloads accumulate, and do not trust a folder merely to make a warning disappear.
Protected View can open certain files in a restricted mode, including some files from the internet or potentially unsafe locations. It is a safeguard, not an Excel fault. If you know a file is safe and need to edit it, verify its source and then use the workbook’s available editing or trust prompt. Turning off Protected View globally is usually unnecessary.
Common Mistakes
- Looking for a separate Enable Trust Center switch. There is no such switch in desktop Excel. The Trust Center is available through Excel Options, and its individual protections are configured separately.
- Enabling every macro to fix one workbook. A global macro setting affects other workbooks too. Verify the file and use a file-specific prompt or a carefully controlled trusted location where appropriate.
- Trusting a broad or shared folder. A trusted folder can contain files you did not personally review. Keep its scope narrow and make sure other people or programs cannot casually add untrusted workbooks.
- Disabling Protected View because a file is inconvenient to edit. First confirm who supplied the workbook and whether it is expected. A security warning is useful information; it does not automatically mean the file is malicious, but it should not be dismissed without checking.
- Changing a setting without noting its original value. If you temporarily alter protection, record what you changed and restore it when the task is done. Otherwise, a one-time workaround can become a lasting reduction in protection.
Tips
- Prefer a one-file decision. When Excel displays a security notification for a workbook you have verified, use the prompt for that file if it offers an appropriate option instead of changing a global default.
- Check the file source. Confirm the sender through a separate, trusted channel if an unexpected workbook asks you to enable content. Do not rely on a familiar display name alone.
- Use narrow trusted locations. Give a trusted folder a clear purpose, limit who can write to it, and review its files periodically. A dedicated folder for approved workbooks is safer than trusting a general-purpose folder.
- Keep security changes reversible. Before editing options, note the original selection or take a screenshot. This makes it easier to restore the normal configuration after troubleshooting.
- Ask your administrator before trying workarounds. On a managed computer, policy may intentionally enforce macro, Protected View, or location settings. Trying to bypass that policy can conflict with your organization’s security requirements.
Troubleshooting
You cannot find Options. Make sure you selected File in the desktop Excel app, not a workbook menu in a browser. In some window sizes, you may need to scroll down the File menu to see Options. If you are using Excel for the web, open the workbook in desktop Excel to access the Windows Trust Center.
Trust Center Settings is unavailable or an option is gray. Your organization may manage the setting through policy, or your Windows account may not have permission to change it. Do not attempt to override a managed setting. Contact your IT administrator and explain which workbook or task is blocked, along with the exact warning text.
A workbook still opens in Protected View. Confirm that you have opened it in desktop Excel and identify which Protected View notice appears. Verify the file’s source and scan it according to your organization’s procedures before allowing editing. Files from the internet, email attachments, or locations Excel considers unsafe may be treated differently. If the file is legitimate but the restriction persists, ask the sender for another copy or consult IT rather than turning off all Protected View protections.
A macro still will not run. First check whether the workbook actually contains VBA macros and whether Excel has displayed a security notification. Verify that the file is from a trusted source. A setting may be controlled by policy, or the file may be blocked for another reason. Avoid enabling all macros to diagnose a single file; ask the file’s author or your administrator for an approved way to access it.
You are using a Mac. Excel for Mac does not use the same Windows Trust Center path or offer an identical set of controls. Look in the Excel app’s Preferences or Settings, including its security or macro security options; labels and availability can vary by version. Do not follow Windows-only instructions such as File > Options on a Mac. Excel for the web also lacks the full desktop Trust Center.
Frequently Asked Questions
Is the Trust Center disabled by default?
No. In desktop Excel for Windows, the Trust Center is built in and available from File > Options > Trust Center. There is no master enable button; you open Trust Center Settings to review individual controls.
Do I need to enable the Trust Center to use Excel?
No. You can use Excel without changing any Trust Center settings. The center manages security options, and the usual recommended approach is to keep protections in place unless a verified task requires a specific adjustment.
How do I enable macros for one workbook?
Only do this if you trust the workbook and its source. If Excel shows a security notification, review it and use its file-specific option when available. Do not enable all VBA macros globally just to run one workbook.
Can I open Trust Center settings in Excel for the web?
No. Excel for the web does not expose the same desktop Trust Center controls. Open the workbook in the Windows desktop app to follow this guide, or consult the relevant security options in the desktop version available to you.
Why can’t I change Trust Center settings on my work computer?
An administrator may have applied organization-wide policy, which can make options unavailable or gray. Ask your IT team to review the setting for your use case. Avoid trying to bypass restrictions, especially for macros or trusted locations.
Should I add a folder to Trusted Locations?
Only if you control the folder, understand which files will be placed there, and need the convenience. Keep it specific and prevent unreviewed downloads or attachments from entering it. A trusted location should not be used as a general workaround for security warnings.
Related
- How to Delete an Excel File in Windows 11
- How to Delete an Excel File in a Browser: Step-by-Step
- How to Delete an Excel File in Office 365
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Insert a Line in Microsoft Word Online EasilyTo insert a line in Microsoft Word Online, open the document, choose Insert > Shapes, select a line…
- Excel Attendance Format: A Clear Monthly Attendance TrackerAn Excel attendance format is a spreadsheet that lists each person in a row and each date in…
- How to Make Columns Bigger in Microsoft Word: A GuideTo make page columns bigger in Microsoft Word, open Layout > Columns > More Columns, then adjust the…
- PowerPoint Table Diagonal Split Cell: Practical MethodsPowerPoint does not provide a true diagonal split that turns one table cell into two independently editable cells.…
- Free Excel Alternatives: Which Spreadsheet Fits You?Yes. LibreOffice Calc is a strong free substitute for Excel on a computer, while Google Sheets is often…
- Is Excel Free? Microsoft 365 Plans and Free OptionsYes—Microsoft Excel is free to use in a web browser with a Microsoft account, and basic use of…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.