Skip to main content

Notifications

Business Central forum
Suggested answer

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

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

Categories:
  • 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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans