If you use Excel Ultimate Suite and macros or add-ins suddenly stop working, the cause is often the Trust Center settings in Excel. This article explains exactly where to find and adjust these settings so your Ultimate Suite tools run smoothly, and what each option means for your security.
Why Trust Center Settings Affect Ultimate Suite
Ultimate Suite is a collection of Excel add-ins that extend the program with hundreds of new functions, data analysis tools, and automation features. Like all Excel add-ins, it relies on macros and ActiveX controls, which Excel’s security system treats as potential threats. The Trust Center is the central hub where you control which macros and add-ins are allowed to run. If the settings are too restrictive, Excel silently disables Ultimate Suite, and you may not even see an error message—the buttons simply don’t appear or the functions return errors.
How to Open the Trust Center in Excel
The path is the same in Excel 2016, 2019, 2021, and Microsoft 365. Follow these steps:
- Open Excel and click the File tab in the top-left corner.
- Click Options at the bottom of the left-hand menu.
- In the Excel Options dialog, select Trust Center from the left sidebar.
- Click the Trust Center Settings… button on the right.
This opens a new window with several categories. The ones that matter most for Ultimate Suite are Macro Settings and Add-ins.
Recommended Macro Settings for Ultimate Suite
In the Trust Center, click Macro Settings. You’ll see four options. For Ultimate Suite to work without constant prompts, choose “Enable all macros”—but be aware this is the least secure option. A better compromise is “Disable macros with notification”, which lets you enable macros when you open a trusted workbook. However, many users find that Ultimate Suite functions still get blocked with this setting because the add-in loads at startup, before you have a chance to approve it.
If you choose “Enable all macros,” also check the box for “Trust access to the VBA project object model” if you use any Ultimate Suite features that manipulate VBA code. This is not required for most functions, but some advanced tools need it.
Add-ins Settings and Disabled Items
In the Trust Center, the Add-ins category lets you manage how Excel handles add-ins. Make sure “Require Application Add-ins to be signed by Trusted Publisher” is unchecked. If it’s checked, Excel will only load add-ins with a valid digital signature from a trusted publisher. Ultimate Suite is signed, but if the certificate isn’t in your trusted list, the add-in may be blocked.
Also, check the Disabled Items category. If Excel previously crashed or you clicked “No” to a security prompt, Ultimate Suite might be listed here. If you see it, select it and click Enable.
Common Problems and How to Fix Them
Even after adjusting settings, you may still see issues. Here are typical scenarios and solutions:
- Ultimate Suite tab is missing: Go to File > Options > Add-ins. At the bottom, set Manage to “COM Add-ins” and click Go. Check if Ultimate Suite is listed and enabled. If not, browse to the add-in file (usually a .dll or .xlam) and add it.
- Functions return #NAME? error: This usually means the add-in isn’t loaded. Check the Add-ins list and make sure it’s checked.
- “Macros are disabled” message: This appears when the file is from the internet or an untrusted location. Right-click the file, select Properties, and check “Unblock” if it’s there. Also, add the folder to Trust Center > Trusted Locations.
- Settings reset after update: Some Excel updates reset Trust Center settings to defaults. Reapply the settings after a major update.
Trusted Locations: A Safer Alternative
Instead of enabling all macros globally, you can add the folder where you store your Ultimate Suite workbooks to Trusted Locations. This way, macros run only in files from that folder, while the rest of Excel stays locked down. To do this:
- In Trust Center, click Trusted Locations.
- Click Add new location…
- Browse to your folder, check “Subfolders of this location are also trusted” if needed, and click OK.
This is the recommended approach for users who want both security and convenience.
Security vs. Functionality: What You Need to Know
Enabling all macros reduces Excel’s protection against malicious code. Only do this if you trust the source of your add-ins and workbooks. Ultimate Suite is a commercial product, so its macros are generally safe, but any macro-enabled file you receive from unknown sources could be dangerous. Always keep your antivirus software updated and be cautious about opening suspicious files, even if your macro settings are permissive.
Frequently Asked Questions
Why does Ultimate Suite work on one computer but not another?
Different Excel installations have different Trust Center settings. The other computer likely has stricter macro settings or the add-in is disabled. Apply the same settings as described above on that machine.
Will changing Trust Center settings affect other add-ins?
Yes, the settings are global. If you enable all macros, other add-ins will also run without prompts. If you use add-ins from unknown sources, consider using Trusted Locations instead.
How do I know if Ultimate Suite is actually loaded?
Check the Add-ins list under File > Options > Add-ins. Also, look for the Ultimate Suite tab in the ribbon. If it’s there, the add-in is loaded.
What if I can’t find the Trust Center button?
If you’re on a managed computer (work or school), the administrator may have disabled access to Trust Center settings. Contact your IT department.
Does Ultimate Suite have its own security settings?
No, it relies entirely on Excel’s Trust Center. There is no separate security configuration within the add-in itself.
Related
General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.
More in this bed
- Show User Library in macOS High Sierra & Sierra
- Device Manager Shortcut: Windows 10 Desktop
- How to Remove Forgotten Passcode from iPhone
- Fix Slow Wi-Fi Problem iPhone X: 9 Steps
- How to Check if a Candidate Accepts Crypto Donations
- How to Listen to Deleted Voicemails on iPhone