web
You’re offline. This is a read only version of the page.
close
Skip to main content

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... / Issue when Configure t...
Small and medium business | Business Central, N...
Suggested Answer

Issue when Configure the Excel Add-In in Business Central

(0) ShareShare
ReportReport
Posted on by Jade Ng 261

Hi all,

I have some questions when configure the Excel Add-In in Business Central (BC160).

I had referred the link as below:

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/configuring-excel-addin

Below are my questions:

1) Is it setting the access token lifetime is compulsory when configure the Excel Add-In?

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/authenticating-users-with-azure-active-directory

Based on this link, Installing the PowerShellGet is required right? And its minimum requirement is for Windows Server 2016 or latest right?

2)  I had hit the error when Specify the WS-federation login endpoint. I had specified a URL in the following format

login.microsoftonline.com/<AAD TENANT ID>/wsfed?wa=wsignin1.0%26wtrealm=<Application ID URI>%26wreply=<Redirect URL>

pastedimage1591509462453v2.png

How can I solve the issue above?

Thank you.

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels Microsoft Employee on at

    Hello,

    Related to 1: it is recommendation when SSO is being used to authenticate users. You can use NavUserPassword with the Excel Add-In. So technically, it is not required but it is highly recommended to do this when using Azure AD SSO. I was able to install the PowerShell commands on my Windows 10 device.

    As per documentation this is a correctly formatted login endpoint:

    WS-Federation Login Endpoint

    login.windows.net/.../wsfed.

    The placeholder [AADTENANTID] represents the GUID of your Azure AD tenant.

    Hope it does help.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 715 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 452 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 371 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans