Excel login - - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Christophe BoutillierChristophe Boutillier 

Excel login -

Hello,

Sorry not sure if this is in the right Topic, please move it as needed,

I'm using a bunch of salesforce report through Excel ( get Data > Online Services > Salesforce Report)
Until today I was able to login with my salesforce credentials and it worked perfectly.

The login popup windows in Excel goes to https://login.salesforce.com/services/oauth2/authorize (at least the title of the pop up says it),
User-added image
after entering my credentials it does not to recognize the password and goes to https://c.salesforce.com/login-message/promos.html
User-added image
and eventually
User-added image

I have tried to adding the Custom domain for my company, and even reinstalled Office. Same issue.

>Getting a bit despaired now, anyone would have an idea ?

Thanks, Best
 
Best Answer chosen by Christophe Boutillier
John KeepJohn Keep
Hi all. We found a workaround for this at our org. It's a registry hack that forces Excel to emulate IE 11 mode when it normally defaults to IE7/compatibility mode which is no longer compatible with the Salesforce login process. If you're not an admin on your machine, you'll have to have someone else make the change but give them this info:
  1. Open Registry Editor and navigate to HKEY_CURRENT_USER\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_BROWSER_EMULATION
  2. Right click --> Select 'New' --> DWORD
  • Name: Excel.exe
  • Value: 2af8 (hex)

All Answers

Paul McCollumPaul McCollum
Try this:

On the Salesforce login Screen, There's a link for 'Use Custom Domain'. Make sure that is filled out correctly.

You can find the appropriate link but logging in to salesforce and then hitting 'log out'. The logged out page's URL is almost always the one you should be using to login to. 
Kimberly SmircichKimberly Smircich
I have the same issue and "Use Custom Domain" does not work for me
Hal ElrodHal Elrod
We are having the exact same issue.
Hal ElrodHal Elrod

Spoke with Salesforce Support. Since Excel is a third-party application, they won't help; it is "out of scope". You know, that crazy niche Excel tool.

It does seem to be related to Summer '20.
 

Kyle HandleyKyle Handley
Having some users with the same issue. I think my session is still cached so I can get in but if I try to re-auth I have the same problem. 
Hal ElrodHal Elrod
If you're cached, don't touch your machine! It will still work. But if you clear cached credentials, you're hosed. [I did that as part of diagnosing issues another user was having]
Perry InaldoPerry Inaldo
We have the same problem. I have not cleared my cache but still does not work. 
Paul McCollumPaul McCollum
It doesn't let me in either. I'm betting they will fix it shortly.
Leo NLeo N
We are having the exact same issue; we did some serious troubleshooting and did not come up with any solution as of yet. 
Christophe BoutillierChristophe Boutillier
Thanks for the answers, this is what I feared..
My guess now is that this is coming from Excel, we did update last week, will post on Microsoft now
Good luck
 
Michal SkaraMichal Skara
My colleague experiences the same issue. We've tried logging into custom domain URL, aded blank page to "Right Frame URL" (My Domain settings, promos page is loaded in case of empty field). Tried reset IE settings as it seems there's some problem with loaded browser core as styles seems not loaded properly. Nothing helped so far.
Leo NLeo N
It doesn't seem like the latest Excel update is at fault. I just reverted back one update to the 6/30/20 (16.0.13001.20266) release (https://support.microsoft.com/en-us/help/2770432/how-to-revert-to-an-earlier-version-of-office-2013-or-office-2016-clic) and the problem did not go away unfortunately. I was hopeful for a second there -- the 7/14/20 Excel update (16.0.13001.20384) included an item that could have been relevant: "Fixed a crash that could happen when trying to create a data connection if you have signed out from your account." (https://docs.microsoft.com/en-us/officeupdates/current-channel#version-2006-july-14)
Paul McCollumPaul McCollum
@asksalesforce told me to check community.powerbi.com 

There's a post at powerbi.com community that points to this salesforce link. 
https://help.salesforce.com/articleView?id=000337175&language=en_US&type=1&mode=1

Sounds like an IE11 config problem.  
Now i'm dizzy from ping pong and going to sit down. 
Ern-ling LimErn-ling Lim
I have exact same issue as @Christophe Boutillier... appreciate if SF could help.. I have a lot of reports that is build with SFDC fed data.. can't imagine if I have to manual retrieve data..  Any help with be greatly appreciated...  
Ern-ling LimErn-ling Lim
Btw,  I have also posted a question to Microsoft at link below (referencing this link)
https://docs.microsoft.com/en-us/answers/questions/50694/power-query-salesforce-data-extraction.html
Ross BarlowRoss Barlow
We've reported this problem to Salesforce Support Response and gotten similar responses to people above (Third Party Software so not our problem). As Paul, Hal and Leo worked out between them, the problem is related to the summer 20 update of SF and not any updates to Excel (thank you for all the work you guys put in getting to the bottom of this).

My mind is boggling at Salesforce refusal to look at their own product, Excel is hardly a niche program. It is as if they have changed our car tires to no longer run on concrete and when people complained have told them to go talk to the people who make the roads. At time of writing 6 out of the top 10 most popular unsolved questions are about not being able to use powerquery through Excel, this is clearly important to users. My charity is using Excel to process safeguarding data and identify children at risk, Powerquery is vital to this process. I sincerely hope they decide to patch this problem themselves rather than waiting for Microsoft to bow to their wishes.
Christopher ViramontesChristopher Viramontes
You know, how all stories have happy endings........I don't see the happy ending here.  Is there a fix to this Login Issue in Excel or not?  We use excel religiously.   Who do we need to call for this?   I tried everything in the IT handbook, nothing is working. 
Stephen MattheeStephen Matthee
It works on PowerBI but what I noticed is the address it goes to is different. in Excel it is going to 
https://c.salesforce.com/login-messages/uk/promos.html

so not sure who changes this?
User-added image
Hal ElrodHal Elrod

Just as update: I've found no one with a solution. Salesforce is like "What's this 'ex-cell' thing that people are talking about?" It's clearly something introduced in their deployment on 7/20.

As an alternative, I've had some success the Free edition of XL-Connector (https://www.xappex.com/enabler4excel-editions-pricing/) It works roughly similiar to Power Query, can be called via VBA, and still logs in reliably. I can't promise it will work for every use case, but it may be better than manually downloading data.

Leo NLeo N
Did some testing around the recommended IE settings on the link posted by @Paul McCollum (https://help.salesforce.com/articleView?id=000337175&language=en_US&type=1&mode=1) but that did not lead to any success (though after clearing the cache and saved credentials the SF login window in Excel no longer displayed the user's login, implying that the browser in Excel does reference those settings in some way).

The current workaround that we're building is via MS Access -- the Access connector to SalesForce still works, so we can query the SalesForce table/report, write it to a table in Access, and then pull that Access table into Excel. This is very far from ideal, obviously requires rebuilding all of the Excel queries, and requires refreshing Access then Excel, but it does work as a stopgap.
Christopher ViramontesChristopher Viramontes
@Leo N - That Sucks!  I will try that.  But what I've built in Excel would need to be redone and that's extra work.  Thanks for sharing. 
Ryan NaegeliRyan Naegeli
We reached out to Salesforce, and this was their response:

This appears to be a widespread issue related to the Summer '20 update as there are quite a few people reporting similar issues in the forums.

https://trailblazers.salesforce.com/answers?id=9064S000000CmJzQAK (https://trailblazers.salesforce.com/answers?id=9064S000000CmJzQAK" style="color:blue; text-decoration:underline)
https://trailblazers.salesforce.com/answers?id=9064S000000CmZdQAK (https://trailblazers.salesforce.com/answers?id=9064S000000CmZdQAK" style="color:blue; text-decoration:underline)
https://trailblazers.salesforce.com/answers?id=9064S000000CmYBQA0 (https://trailblazers.salesforce.com/answers?id=9064S000000CmYBQA0" style="color:blue; text-decoration:underline


Bottom line, they've tied this issue to the Summer 20 update, and they're working on a solution.
Paul McCollumPaul McCollum
Update: Microsoft has the ball. 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?messageId=cc8240c3-0511-40df-be8f-bc4027ee200b&auth=1
 
Krishna DadiKrishna Dadi
follow below thread
https://answers.microsoft.com/en-us/msoffice/forum/all/power-query-excel-365-to-salesforce-sandbox/f0e2810b-4ac1-4fdc-b188-4ec25b227462
Almir JuniorAlmir Junior

I have the same problem. =(

I tried to check if the problem was in TLS 1.2, or in connection with the .NET Framework, however without success. Well, at least I feel better knowing that the mistake was not just me.

Thank the others for the search for palliative solutions to the cases, while Salesforce and Microsoft do not solve this case.

Christopher ViramontesChristopher Viramontes
MS Access only works for Objects, it does not work to import Reports.   This work around is not viable for our needs.   How can we import Reports on MS Access is the key? 
Hal ElrodHal Elrod

FYI: Salesforce has acknowledged they are working on the issue.

Track here: https://trailblazer.salesforce.com/issues_view?id=a1p4V000001YqEeQAK

John KeepJohn Keep
Hi all. We found a workaround for this at our org. It's a registry hack that forces Excel to emulate IE 11 mode when it normally defaults to IE7/compatibility mode which is no longer compatible with the Salesforce login process. If you're not an admin on your machine, you'll have to have someone else make the change but give them this info:
  1. Open Registry Editor and navigate to HKEY_CURRENT_USER\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_BROWSER_EMULATION
  2. Right click --> Select 'New' --> DWORD
  • Name: Excel.exe
  • Value: 2af8 (hex)
This was selected as the best answer
Christophe BoutillierChristophe Boutillier
Thanks John, this works for me !
Christopher ViramontesChristopher Viramontes
THIS WORKS FOLKS!  IT WORKS, I LOGGED STRAIGHT IT!  Thanks John! 
Leo NLeo N
YES! Worked for me as well. 
Almir JuniorAlmir Junior
Thx a lot, Jhon!
Worked perfectly. :)