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... / Edit in Excel / Office...
Small and medium business | Business Central, N...
Suggested Answer

Edit in Excel / Office Add-in feature not working in WIN11

(0) ShareShare
ReportReport
Posted on by Catharsis 65

Hi.

As we are slowly updating users workstation operating systems to Windows 11 we have noticed that Edit in Excel feature is simply not working for this version of Windows and it's becoming a huge issue in accounting department. We currently still have users using WIN10 and for them everything is still working as expected.

Error Loading Metadata Details: Please check server connection, verify the current user has proper access, and try again. Error message: ''

Yes, the error message is empty string

Environment:

MS Office Home and Business 2019

On prem Business Central version W1 18.1 (Platform 18.0.24800.26311 + Application 18.0.23013.23795) with Azure hybrid AD oauth.

I have the same question (0)
  • Nitin Verma Profile Picture
    Nitin Verma 21,698 Moderator on at

    Hi Catharsis ,

    Can you please check if you have installed Excel add in along the BC?

    Thanks.

  • Suggested answer
    Catharsis Profile Picture
    Catharsis 65 on at

    Okay guys, I'm going to answer this one myself since I've found out what the issue was.

    Somehow I was able to open Excel add-in DevTools and see errors in the console. and there were errors regarding insecure HTTP sources. So I found out that for our main BC instance oData was not configured to use HTTPS/SSL. We usually use different instance for oData web services.

    After configuring this instance to use SSL on different port everything work on these Windows 11 systems too.

    BUT, now the question arises, HOW ON EARTH did it work on Windows 10 workstations? How does operating system have anything to do with how MS services (az689774.vo.msecnd.net/.../*) treat HTTP sources. This quite boggles my mind.

    Also this add in should be updated to add proper error reporting to feedback this kind of issue since it's very hard to debug empty error strings that are very common when it comes to everything Microsoft.

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