Edit in Excel option for On Premise Business central
Register and configure an application in Microsoft Azure to connect Excel Sign to Azure Portal App registrations- New Registrations Highlighted checkmark parameters values change as per below in Manifest In the editor, set "oauth2AllowIdTokenImplicitFlow" and "oauth2AllowImplicitFlow" keys to true : "oauth2AllowIdTokenImplicitFlow": true, "oauth2AllowImplicitFlow": true, In the "replyUrlsWithType":[] key, add the following lines: { "url": "https://az689774.vo.msecnd.net/dynamicsofficeapp/v1.3.0.0/*", "type": "Spa" } Grant the Excel add-in application permission to access the Business Central application Web API. Give the Microsoft Entra application for the Excel add-in delegated permission to access the Business Central application Web API, which you exposed earlier in this article. This permission allows users of the Excel add-in to access the ODat...