Allow Add-Ins from the Office Store
Do you see “Microsoft 365 has been configured to […] prevent add-ins […] from running”? Here's how to revert to default settings.
This notice is displayed if the administrator has used a different setting for Microsoft Office.
To revert to the default configuration, your organization's administrator can follow these three steps:
Step 1 – Open Administration
Open the Admin Center (https://admin.microsoft.com/) or click on the menu item in your Microsoft 365 account Admin.
Step 2 – Open Apps and Services
Switch to Settings › Org Settings › Services and click User owned apps and services.
You may first have to click on “Show all” in the navigation so that the “Settings” menu item is displayed.
Step 3 – Restore default configuration
Enable “Let users access the Office Store” setting to allow access to Microsoft’s Office Store. Click “Save”.
Then restart Excel so that the changed settings take effect.