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... / 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 3,967

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
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,105 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,529 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 3,967 on at

    Hi MahGah,

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

  • Olister Rumao Profile Picture
    Olister Rumao 3,967 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,529 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
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,105 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 3,967 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

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 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans