Microsoft is continually improving the security of its customers’ data. Organizations often empower employees to work with business data in Excel using the Microsoft Dynamics Office Add-In, commonly referred to as the Excel add-in. To further secure the connection between the Excel add-in and Dynamics 365 Business Central, Microsoft will roll out a change that requires administrators to update their Azure Active Directory (Azure AD) configuration to continue using the add-in.
Microsoft will roll out changes to the Excel add-in starting July 1st, 2022.
For business continuity, administrators can prepare for the change at any time prior to this date.
This affects organizations that have configured the Excel add-in to work with Business Central on-premises or similar deployment variants, such as hosted or private cloud. Business Central online customers are not affected.
After Microsoft updates the Excel add-in, users will no longer be able to sign in to the add-in and the sign-in process will appear to halt without completion. This will occur when using the Edit in Excel feature in the Business Central clients, or for any new and existing Excel files that utilize the add-in. The inability to connect Excel to Business Central applies to all Excel clients and Excel versions supported by the add-in and applies to all versions of Business Central including the latest major update 20 and subsequent updates.
A simple, one-time configuration adjustment is required for organizations to continue using the add-in within that organization. The adjustment requires administrative permissions, can be done just once for the whole organization and can be completed in less than 5 minutes.
To configure the Azure AD registration associated with the add-in to use the new single-page application Redirect URI instead of the legacy Web Redirect URI, follow the instructions below
Your experience may vary if your Azure AD App registration also includes Redirect URIs for other services. You should not change other Redirect URIs for other services or for the Business Central Web client as part of this change. To check if other services are affected by similar security hardening exercises and require re-configuration, please contact the service provider.
Learn more about Registering your application with your Azure Active Directory tenant.
Learn more about Setting up the Excel add-in for Business Central on-premises.
If you have any questions or need any assistance. Our 24/7 support squad is here to help. You can reach us by emailing a support ticket to support@innovia.com, by calling 855-856-8764, or by submitting a ticket through our website.