Forum Discussion

christophelel's avatar
christophelel
Copper Contributor
Jul 21, 2020

Excel Power Query fails to connect to salesforce

since last week, in Excel, I cannot import data from Salesforce Report. It fails to login to Salesforce. no error message. Login screen is presented again. Office365 Enterprise, Excel 2007, win 10 ...
Need Help
iw-prb's avatar
iw-prb
Copper Contributor
Jul 22, 2020

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

  • aaronhfx's avatar
    aaronhfx
    Copper Contributor
    Jul 24, 2020

    iw-prb I can confirm the rollback on office does not correct the problem tested on build 365 App for enterprise 0365 version 2007 to 2006  (2005 was unavailable to select.)

     

    I also tested build office 2019 ProPlus and rolled back version 1908 to 1808 with the same issue.

     

    I also noticed when trying to login with Salesforce in excel that it's trying to load .NET  I tried rolling  .net 4.8  back to 3.5  with no luck. same issue.

     

    I have noticed with one device running build 365 App for enterprise 0365 version 2007 that the  Salesforce credentials are saved to the data source setting under getting data this allows me to login in to salesforce with the credentials held in excel.

     

    currently looking into were are these credentials saved in excel and how-to manually enter them.  

     

    Aaronhfx

     

     

     

     

  • AndriuUrbina's avatar
    AndriuUrbina
    Copper Contributor
    Jul 23, 2020

    Hi all,

     

    Having the same issue since Monday. So far it is blocking us to continue with some critical business processes that we were managing using this kind of connection.

    For your info, we have Office 365 ProPlus version, and Excel is in version 1908 so not pretty sure the solution of downgrading excel fro 2006 to 2005 will work (I hope so).

    Hope we get a solution soon.

     

    Thanks,

    Andriu

Resources