function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Patricio Alejandro NavarretePatricio Alejandro Navarrete 

I can't connect to Salesforce from Excel

Hi,
I haven't been able to import Salesforce object data from Excel for a few days. My microsot license allows me to get data from Salesforce but when I enter my credentials through the oauth2 service in excel, I don't get a response and the url changes to https: // https: //c.salesforce.com/login- messages / promos.html

This issue started one day after we renewed Salesforce licenses. We have the Enterprise edition.

Has anyone had this problem or know how to fix it?

Before Login
Before login

After to try loginAfter login
 
Best Answer chosen by Patricio Alejandro Navarrete
VinayVinay (Salesforce Developers) 
Hi Patricio,

I checked further on this and this seem to be an issue from Microsoft office.

Kindly reach out to microsoft support team using below link.

https://powerbi.microsoft.com/en-us/support/
https://trailblazers.salesforce.com/answers?id=9063A000000pFmBQAU

https://help.salesforce.com/articleView?id=000313607&type=1&mode=1(End of Support for Excel Add-In from Connect for Office)

Thanks,
Vinay Kumar

All Answers

VinayVinay (Salesforce Developers) 
Hi Patrico,

Can you try re-installing Microsoft Office?

Reference:
https://trailblazers.salesforce.com/answers?id=90630000000Cq7RAAS

Thanks,
Vinay Kumar
Patricio Alejandro NavarretePatricio Alejandro Navarrete
Hi Vinay,
I already tried re-installing, but I still have the problem
VinayVinay (Salesforce Developers) 
Hi Patricio,

I checked further on this and this seem to be an issue from Microsoft office.

Kindly reach out to microsoft support team using below link.

https://powerbi.microsoft.com/en-us/support/
https://trailblazers.salesforce.com/answers?id=9063A000000pFmBQAU

https://help.salesforce.com/articleView?id=000313607&type=1&mode=1(End of Support for Excel Add-In from Connect for Office)

Thanks,
Vinay Kumar
This was selected as the best answer
Patricio Alejandro NavarretePatricio Alejandro Navarrete
Thanks Vinay, you're right, this is a Microsoft Office issue
Thibault ChevalierThibault Chevalier
Message found in Microsoft forum :
"This is now reported as a Known Issue with Salesforce on the Trailblazer Community.
https://trailblazer.salesforce.com/issues_view?id=a1p4V000001YqEeQAK
 
Please click "This Affects Me" so that this issue can get increased visibility"

Upvoted.
Kirill_YunussovKirill_Yunussov
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.