web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Dynamics Business Cent...
Small and medium business | Business Central, N...
Suggested Answer

Dynamics Business Central Excel add-in issue

(0) ShareShare
ReportReport
Posted on by SSCHWEITZER 15

hello
we use Business Central with Office 365 
our users have Office 365 software installed on their computers.
on Business central, when they extract data to be modified in Excel the Microsoft Dynamics Excel add-in doesn't connect on the server

5466.Capture.PNG

I don't know how wher enable this option

If I open this file in Excel Online it works

7723.Capture1.PNG

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    You must give the Azure AD application for the Excel add-in delegated permission to access the Business Central application Web API in Azure AD (which you exposed earlier in this article). This allows users of the Excel add-in to access the OData web services to read and write data.

    From the application's Overview, select API Permissions.

    Select the Add a permission

    On the APIs my organization uses, select the Business Central application.

    Select Delegated permsission.

    Select the permission from the list, and then select Add Permission.

  • SSCHWEITZER Profile Picture
    SSCHWEITZER 15 on at

    I'm new as Admin AD Azue

    is it in Azure Active Directory Admin center that I can find it?

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at

    Hello,

    I do not think this is related to missing consent in Azure AD as it does not work in OnPrem Excel Only. It does work in a browser.

    The first screenshot is about loosing internet connection. Does this happen on all computers or on just one. Is the account you are authentication with added as a service in Excel (user name at the top of the screen at the right hand side).

    If you raise a support ticket to Microsoft via your CSP, my ask would be to get a Fiddler trace to see what is really happening (assuming the internet connection does not get lost of course).

    Download:

    www.telerik.com/.../fiddler

    Configure it to decrypt ssl traffic, in Fiddler select Tools, Options, HTTPS, select Decrypt HTTPS traffic, and the other two options are optional, OK:

    Select Tools, Win8 Loopback Exceptions (I did select all, but that is probably an overkill), Save Changes:

    Thanks.

  • SSCHWEITZER Profile Picture
    SSCHWEITZER 15 on at

    Hello

    Here is the capture during the opening of the file in Excel

    fiddler.txt

  • Community Member Profile Picture
    Community Member on at

    check the firewall

    is the port opened inbound/outbound?

  • SSCHWEITZER Profile Picture
    SSCHWEITZER 15 on at

    which port must be opened?

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    I think the client port and OData port are enough

  • SSCHWEITZER Profile Picture
    SSCHWEITZER 15 on at

    it is not clear for me as I am not the main administrator of Business Central

    where and how can I find the ports used by BC?

    what are the port numbers or protocol?

    I have the same issue if I am at home with the Windows firewall

  • Community Member Profile Picture
    Community Member on at

    you may find the ports' number via Administration.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,362

#2
YUN ZHU Profile Picture

YUN ZHU 867 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 607

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans