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

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... / Issue with Excel Add-in
Small and medium business | Business Central, N...
Answered

Issue with Excel Add-in

(0) ShareShare
ReportReport
Posted on by Olister Rumao 4,009

Hi All,

I have been using Edit in Excel functionality and after updating the BC Production Environment to v19.3, all the users are facing the following issue.
ExcelAdd_2D00_In.png

I cleared Excel Cache, changed sign-in, reinstalled Excel. But doesn't resolve the issue.
Kindly advise.

Thanks.

I have the same question (0)
  • Suggested answer
    IB-29041624-0 Profile Picture
    IB-29041624-0 1,187 Moderator on at

    Have you gone through this setup after upgrading to 19.3?

    docs.microsoft.com/.../configuring-excel-addin

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,613 on at

    In addition to Inge feedback

    1) Assuming you are on SaaS version. do all users have required permission?

    cargas.com/.../

    2) is this happen in one page (like customer) or it is in every page?

  • Olister Rumao Profile Picture
    Olister Rumao 4,009 on at

    Hi MahGah,

    I have tested this suggestion. Everything seems fine.
    However the issue is not resolved.

  • Olister Rumao Profile Picture
    Olister Rumao 4,009 on at

    Hi Inge,

    I'm using BC Online.

    These steps are for BC-OnPrem.

    Kindly advise!

    Thanks.

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,613 on at

    Hi Olister

    Thanks for info. It is a strange message. Looks like excel cannot connect to BC.  Looks like Edit in Excel creates webservice based on page id and then use that.

    Can you check and see if you can access one of the published ODATA in web service  from Excel (something like this thatnavguy.wordpress.com/.../)

    This is the code for edit in excel

       procedure EditWorksheetInExcel(PageCaption: Text[240]; PageId: Text; "Filter": Text)

       var

           ServiceName: Text[240];

       begin

           ServiceName := FindOrCreateWorksheetWebService(PageCaption, PageId);

           OnEditInExcel(ServiceName, Filter);

  • Suggested answer
    IB-29041624-0 Profile Picture
    IB-29041624-0 1,187 Moderator on at

    If this is BC online i would suggest to raise a support ticket with Microsoft and get their help to investigate this.

    The only other thing i think can come into play here if the user rights are ok is that it might be some security policies that are enforced on all your computers in the same network.

    Then i would try for a computer that is not in your network or have enforced any company security policies.

  • Suggested answer
    Olister Rumao Profile Picture
    Olister Rumao 4,009 on at

    Hi Team,

    I got the resolution to the issue.
    There was a Webservice and Edit in Excel was trying to create one more webservice.

    I have posted my debugging steps on https://olisterr.blogspot.com/2022/02/how-to-resolve-edit-in-excel-issues.html

    Thanks All.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,872 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,110 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 892

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans