For more information, see Authenticating Users with Azure Active Directory. The Business Central Server instance, clients, and users must be configured for Azure Active Directory (Azure AD) authentication, including OData. Your on-premises deployment must meet the following prerequisites:ДЄzure Active Directory (Azure AD) used to authenticate users. The Excel add-in is not available in the mobile apps. The add-in is based on the Microsoft Dynamics Office Add-In available from the Office Store.ДЇor more information about how users work wth Excel from Business Central, see Viewing and Editing in Excel From Business Central. When this add-in is set up, the Edit in Excel action is added.

But the Open in Excel action doesn't allow them to push changed data back to Business Central. Without this add-in, users can open a list page in Excel from the Open in Excel action on the page. Users can get fresh data from Business Central into Excel and push updated data from Excel to Business Central.

You can set up the Business Central deployment to support an add-in that enables users in the Business Central client to work with data from list pages in Excel. This article does not apply to the older Excel add-in that was available for installation with the Dynamics NAV Client connected to Business Central client by using the Business Central Setup in versions older than 2019 release wave 2.

How to enable editing in excel