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 :
Small and medium business | Business Central, N...
Answered

Edit In Excel Forcing Sign In Every Time it's Opened

(1) ShareShare
ReportReport
Posted on by 6
Our team uses the "Edit in Excel" functionality in BC many times a day to update Cash Receipt Journals. Since 05.01.2026 the "Edit in Excel" functionality is forcing a sign in every time Excel is opened. The sign in does not require MFA. We have been digging into permissions and tokens, though are not finding any obvious answers. Is anyone else experiencing this issue or found reasons or solutions?
I have the same question (0)
  • Suggested answer
    Teagen Boll Profile Picture
    2,178 Super User 2026 Season 1 on at
    There seems to be some authentication and login issues with the Excel add-in. I have seen clients reporting it. You can read a previous thread here: Business Central Excel Add-in failing to authenticate
     
    Some suggestions in that thread may help you, otherwise I would report the issue to Microsoft either through a support case or via your Partner.
     
    Best,
    Teagen Boll
    Social: LinkedIn
  • Suggested answer
    Gregory Mavrogeorgis Profile Picture
    1,195 Super User 2026 Season 1 on at
    Hi,

    Yes this is the same problem many people are seeing since 1 May 2026. Microsoft pushed an update on the authentication library used by the Office add-in and after that the token is not kept anymore between Excel sessions. So every time Excel opens, a new sign in is asked. MFA does not always show because the device is still trusted, but the prompt itself comes up.

    There is an open ticket from Microsoft about it, https://admin.powerplatform.microsoft.com/support/knownissues/6355973, the issue is recognised on their side.

    The workaround that solves it for most users is to close Excel fully, then delete what is inside the folder %LOCALAPPDATA%\Microsoft\Office\16.0\Wef. Some cases need also the folder %LOCALAPPDATA%\Microsoft\IdentityCache to be emptied. After this, the sign in stops appearing every time.

    If the issue still continues, the next step is to remove the Microsoft Dynamics Office Add-in from Excel, Insert, My Add-ins, Manage, Remove, and install it again from AppSource. This forces a clean token.

    For now no permanent fix from Microsoft, only the cache clean works as workaround until they patch it.

     

    ✅ Tick the checkbox below to mark the answer as verified, if it helped resolve your question.
     
    Regards
    Gregory Mavrogeorgis
     
  • Suggested answer
    YUN ZHU Profile Picture
    100,185 Super User 2026 Season 1 on at
    Business Central known issue: Microsoft Dynamics Office add-in sign in issues (Excel Add-in)https://admin.powerplatform.microsoft.com/support/knownissues/6355973

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,957 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 956 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 645 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans