You need to sign in to do that
Don't have an account?
Patricio 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
After to try login
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
After to try login
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
Can you try re-installing Microsoft Office?
Reference:
https://trailblazers.salesforce.com/answers?id=90630000000Cq7RAAS
Thanks,
Vinay Kumar
I already tried re-installing, but I still have the problem
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 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.
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.