Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Upgrading from BC20 GB to BC21 GB - Export to Excel error

Posted on by 10

Hello,

I have made several Upgrades from BC20 GB to BC21 GB for a number of databases, and a few of them have had issues post-upgrade when trying to use any function which exports to excel. E.g. When going to configuration packages, creating a new one and clicking on Export to Excel returns the following error message.

20230127_5F00_211740.jpg

This seems to be a DLL issue, and BC21 started the first change from .NET Framework to .NET Standard.

Has anyone had this issue when doing an upgrade? This applies to any of the BC21 GB versions.

Thank you

  • Suggested answer
    aelagha Profile Picture
    aelagha 10 on at
    RE: Upgrading from BC20 GB to BC21 GB - Export to Excel error

    I have resolved this issue. What I have forgotten to mention is that the app we are working on has some custom .NET addins. A few of those addins have a dependency on DocumentFormat.OpenXml.dll v2.8.1

    BC21 has a number of DLLs in the Service folder, including the new DocumentFormat.OpenXml.dll v2.19.0, which has a number of changes compared to v2.8.1

    These changes are what caused this error, but more importantly, it happened because the publishing of the Base application happened AFTER the older DLL file was copied into the folder, causing the Base application to unfortunately use the older version instead.

    The easy solution here is just to publish the Microsoft apps before copying any additional DLLs into the Service folder.

  • aelagha Profile Picture
    aelagha 10 on at
    RE: Upgrading from BC20 GB to BC21 GB - Export to Excel error

    This wouldn't be necessary as it requires to have Azure AD authentication as a prerequisite, which would be a huge blocker for existing clients who are still using Windows Authentication.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Upgrading from BC20 GB to BC21 GB - Export to Excel error

    Have you been through this setup?

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

  • aelagha Profile Picture
    aelagha 10 on at
    RE: Upgrading from BC20 GB to BC21 GB - Export to Excel error

    Hi Inge,

    I have tried BC21.3, but sadly still the same issue. It seems to be fine when using a demo database, but not with a database that's been upgraded.

    Kind regards,

    Ahmed

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Upgrading from BC20 GB to BC21 GB - Export to Excel error

    Are you on the latest cumulative update for BC21?

    If not i would recommend you try to use the latest available cumulative update.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,963 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans