web
You’re offline. This is a read only version of the page.
close
Skip to main content
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,045 Moderator on at
    RE: Issue with Excel Add-in

    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
    RE: Issue with Excel Add-in

    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
    RE: Issue with Excel Add-in

    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
    RE: Issue with Excel Add-in

    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
    RE: Issue with Excel Add-in

    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,045 Moderator on at
    RE: Issue with Excel Add-in

    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
    RE: Issue with Excel Add-in

    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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 2,568

#2
Sumit Singh Profile Picture

Sumit Singh 2,536

#3
YUN ZHU Profile Picture

YUN ZHU 2,015 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans