Excel Power Query fails to connect to salesforce

christophelel FYI, opened support tickets with SF and MS. SF says this is MS' problem. MS says to try rolling Excel back to version 2005. Haven't tested myself but here you go:

Please perform the following for installation of version 2005, please also choose the version correctly.
Office Deployment Tool Installation

1. Download the Office Deployment Tool (https://www.microsoft.com/en-us/download/details.aspx?id=49117)
2. Open the downloaded file and extract it to an easily accessible location. i.e. create a folder named ODT in Drive C (C:\ODT)
3. Create Configuration file by going to https://config.office.com select "Create" new configuration file. Sample Below
a. Architecture: 32-bit
b. Office Suites: Office 365 Business
c. Update Channel: Semi-Annual, Latest
d. Languages: Match Operating System
e. Installation: Office Content Delivery Network (CDN)
Note: For options not in sample, no need to make changes on them
4. Click on Export on upper right
5. Check "I accept" then click Export
6. Copy the configuration.xml file downloaded and paste it to C:\ODT and replace existing file if conflict occurs
7. Open Command Prompt with admin rights
8. Change directory to ODT folder by running:
a. Cd C:\ODT
9. Type "setup.exe /download configuration.xml" and hit Enter
10. After download has finished, type "setup.exe /configure configuration.xml" then hit enter and wait for the installation to finish