Skip to main content

Notifications

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

Edit-In Excel doesn't work when using a load balancer

(0) ShareShare
ReportReport
Posted on by 5

We have 2 Business Central servers (AS + IIS website) behind an A10 Network Load Balancer. Those servers host application Business Central with an Excel-Add In feature. When using 'Edit In Excel' feature throught load balancer, it doesn't work. But if i use 'Edit In Excel' without the NLB Load Balancer, it works fine. (when entering directely the name of the servers or when modifying my host file).

I have opened a ticket to my hosting partner but they don't see anything on the NLB A10. I'm pretty sure it's a network problem with the NLB A10 load balancer

Business Central version is 19.1 and is On-Premise  with an SSO authentication in Azure Active Directory.

The following message is displayed...

Details:
Please check the connection to the server and whether the current user has suitable access, then try again. Error message

Any help would be appreciate...Thank you

  • Suggested answer
    Andy Sather Profile Picture
    Andy Sather on at
    RE: Edit-In Excel doesn't work when using a load balancer

    Hello,

    If you don't get further responses to this issue, you may want to raise a support request to Microsoft support via your CSP / Partner.

  • RE: Edit-In Excel doesn't work when using a load balancer

    5850.error.jpg

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

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans