I'm encountering an issue with a specific user account on a specific machine. This is an online deployment.
When this user selects "Edit in Excel" from any page, the file successfully downloads in the browser (Chromium-based Edge) and successfully opens in Excel. When the Enable Editing button is selected in Excel, the add-in loads and appears to authenticate with the server. This goes on for a moment and the add-in displays the error "Failed to retrieve the server config" with no error code (it's displayed as " ").
I have been unable to replicate this error on any other machine or with any other user on this particular machine:
- I can login to the add-in and Excel with another user's credentials and it works successfully on this machine (not a problem with the add-in?).
- I can login to the add-in and Excel with this user on any other machine and it works successfully (not a permission or license error?).
- All machines are Windows 10 and AAD connected.
- I have run Fiddler with all "immersive" apps exempted and there are no 500 (or any other) errors.
- The Server URL is https://exceladdinprovider.smb.dynamics.com but we have also tried our online tenant URL.
- The Office upload cache has been cleared.
- There are no firewall rules blocking relevant ports on either the client or network (I think Fiddler would have revealed this too...)
The only notable information I can find other than the error notification itself is that when the options dialog is opened for the failed user, it grabs an App correlation ID, but fails to populate any other items I would be used to seeing on a successful data connection (User agent, "Prefer", or Environment).
For an on-prem installation I would start looking at logs from the backend but I cannot find a way to do that with the online version...
I've pored through every relevant post for Business Central and NAV, both from Microsoft and third-parties, and I've come up with nothing helpful. I am incredibly grateful for whatever help anyone has!
Where would you look next? Thank you!!