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

Community site session details

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

Microsoft Dynamics Office Add-in disappears or shows blank pane

(3) ShareShare
ReportReport
Posted on by 6
After recent Microsoft Office updates, the Microsoft Dynamics Office Add-in no longer loads consistently in Excel. Even when the add-in is installed successfully, it is not retained between sessions — each time Excel is restarted, the add-in must be reinstalled.
Additionally, we have several Excel files that were previously designed and saved with the Dynamics add-in (custom layouts, queries, and table designs). When these files are opened:
  • On some computers, the add-in loads correctly and the data connection works as expected.
  • On other computers, the add-in pane appears blank (white screen), or the add-in does not load at all.
This behavior occurs even with files downloaded directly from Business Central (“Edit in Excel”).
 
-Excel version: Microsoft® Excel® for Microsoft 365 MSO (Version 2510 Build 16.0.19328.20178) 64-bit
-Operating system: Windows 11
 
Troubleshooting steps performed:
Excel is fully updated to the latest version.
I have repaired Office using the Online Repair option.
I deleted the Office add-ins cache folder: %LOCALAPPDATA%\Microsoft\Office\16.0\Wef
After clearing the cache, the add-in no longer loads at all, even after reinstalling it from the Office Add-ins Store.
 
Workaround found:
I’ve checked that other computers in our organization are running an earlier Excel version, so I reverted my installation to Version 2510 (Build 16.0.19328.20144). After reverting, some machines experienced minor errors during the first load of the add-in, which were resolved either by reinstalling the Dynamics Office Add-in or by clearing the Office add-ins cache.
I hope Microsoft can release a fix for this issue soon.
 
 
 
Edited: That workaround is no longer working.
I have the same question (0)
  • Suggested answer
    NAV_with_Narang Profile Picture
    2,274 Moderator on at
    Microsoft Dynamics Office Add-in disappears or shows blank pane
    Raise this with MS Support. The issue, as you have mentioned, can stem from many possible reasons from excel versions and/or BC version/localization. As you might've seen in a lot of questions regarding excel add-in on this community, the workarounds seldom tend to work beyond the first few tries

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,351

#2
Sumit Singh Profile Picture

Sumit Singh 2,072

#3
YUN ZHU Profile Picture

YUN ZHU 1,807 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans