Hi all,
I’m having an issue with Edit in Excel for a single user in our Business Central environment and can’t seem to shift it.
Environment
- Business Central: online, version 27.1
- OS: Windows 11
- Excel: Microsoft 365, 64-bit
- Dynamics Office Add-in: deployed via centralised deployment in the Microsoft 365 admin centre
- User: SUPER in BC + Edit in Excel permission set explicitly added
This user is set up in the same way as everyone else, and other users can use Edit in Excel without any problems.
Problem
Up until a few days ago, Edit in Excel was working fine on this user’s PC. Now:
- When she clicks Edit in Excel in Business Central:
- Excel opens
- The Dynamics add-in panel on the right is just solid grey
- No text, no sign-in prompt, no error message, not even a loading spinner
- This happens for both new exports and existing Edit in Excel files that used to work.
- The same BC pages export fine for other users and load the add-in correctly.
It looks like the add-in starts but never actually initialises or pulls any server/environment details.
What I’ve checked so far
- Excel is definitely 64-bit and fully updated.
- Windows 11 fully patched.
- Business Central is on 27.1.
- User has SUPER + Edit in Excel permissions in BC.
- Add-in is deployed centrally and the user is in the assignment scope.
- Behaviour is the same with existing files and fresh downloads from BC.
Questions
- Has anyone seen the Dynamics Office Add-in pane just stay completely grey/blank like this for a single user?
- Are there known issues with BC 27.1 + Excel 64-bit that could cause this?
- Is there a recommended way to reset/clear whatever cache/auth/profile the add-in uses for a specific user on a specific machine?
- Any other things you’d suggest checking (Office profile, privacy settings, registry, tokens, etc.) before I go down the route of rebuilding the user’s Windows profile?
Any pointers or “we’ve seen this and did X” would be really appreciated.
Thanks!