Excel Power Query fails to connect to salesforce

There is a workaround available:

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_o365b/power-query-excel-365-to-salesforce-sandbox/f0e2810b-4ac1-4fdc-b188-4ec25b227462?page=5&rtAction=1595871465775

​

MS support is working on a structural fix. in the meantime a non official workarround that worked for me (to use at your own risk) is:

• For 32-bit versions of Excel running under 32-bit versions of Windows and 64-bit versions of Excel running under 64-bit versions of Windows, the key is 

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_BROWSER_EMULATION

• For 32-bit versions of Excel running under 64-bit versions of Windows, the key is 

HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_BROWSER_EMULATION

Either way, please create a new DWORD 32bit value under that key with a name of excel.exe and a value of 0x2af8 (or decimal 11000).

It forces excel to use another version of ie.

 

Confirmed that this workaround is working. However, if the user is seeing messages about their password being incorrect or a token is required, you need to add in that users IP into the Network Access in salesforce

https://(DOMAIN).my.salesforce.com/05G

Adding in the Users Token to the login information won't be a successful workaround for the above.