Forum Discussion
Excel blank screen / unresponsive when authenticating sharepoint online data source
I'm having this strange issue when I attempt to use power query to consume a sharepoint online resource. When I get to the authentication window, I select Microsoft Account and a window opens up ...
I see no one posted a solution for this. I spent like last 9 hours to fix this. I tried all these:
- Reinstalling office
- Updating office to latest version
- Removing all credentials from Windows Credentials
- Adding below sites to Trusted Sites under IE options (with and without "Require Server verification (https:) for all sites in this zone":
https://*microsoftonline.com
https://*sharepoint.com
https://*windows.net - Reset IE settings.
Even then there was no fix. Lastly I tried running excel in safe mode and tried it and it worked! So now I figured I have a add-on which is causing issue. I simply disabled all add-on, restarted excel and I could login.
Edit: The add in which gave trouble was "logioptionsexceladdin". This is used by Logitech MX Master 3 mouse
- This was a big help. I have the exact same mouse and had the exact same issue. Thanks!
