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.