Excel Power Query Salesforce login popup is unresponsive.
Trailblazer Community

Excel Power Query Salesforce login popup is unresponsive.

Authentication

Last updated Today ·Reference W-7883670 ·Reported By 325 users

In Review

Summary
When authenticating using Power Query in Excel with Salesforce (a Microsoft product), the login box doesn’t respond and users cannot login. Note that their product is often referred to as 'Excel Connector'

Repro
1. In Excel navigate to Get Data --> From Online services --> From salesforce object --> Production (Or Sandbox) --> Supply credentials in the authentication pop.
2. The screen will change URLs to …. /login-messages/in/promos.html but stay populated with existibg credentials and Salesforce login is unsuccessful.

Workaround
See below.

Updates
As noted also in the forum here: 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

The current workaround is creating a Registry key to force Excel to emulate IE 11. NOTE: editing the registry incorrectly can cause major problems on the local machine. It is advised to back up the registry, or key your are working on, before making changes. If needed see: https://support.microsoft.com/en-us/help/322756/how-to-back-up-and-restore-the-registry-in-windows.

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, navigate to:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_BROWSER_EMULATION here create a new DWORD 32bit value under that key with a name of Excel.exe and a value of 0x2af8 (or decimal 11000)

Or For 32-bit versions of Excel running under 64-bit versions of Windows, navigate to:
HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_BROWSER_EMULATION here create a new DWORD 32bit value under that key with a name of Excel.exe and a value of 0x2af8 (or decimal 11000)

NOTE: If other apps or integrations make Web calls from Excel using different browser emulation this workaround could affect those calls.

Reported By (325)

哲哉 清水 sravanthi sanka Yvonne Wanjiru Randall Magliozzi Amy Cressman Albert Marrache Jen Russo Saicharan Reddy K Christelle Duverger Zach Brown IT Support Lukasz Michalski Allan Pearson Charmaine Rhule sarah knebusch Alwyn Lane Don Payne Altostratus Tecnologia Cathy Twine Josh Wood Meg Otto Farhan Siddiqui Matthew Bender Jason Howe (System Admin) Jakub Stawiarski Sergio Otero Felipe Marc Maschke Nicky Duggan Douglas Bratten Martin Krchnak Petr Novotný Pim Stolwijk R R Kerri Shields Hane Crevelari Murilo Pinto Juan D. Robles Robert Edsall Ben Lehman Almir Sarvan Omar Gonzalez yuriy bogatyrev Natalia Potasheva 恵 平垣 Peter Keller Nancy Boarman Roy Troutman Brady Davis Keyne Damiens Jessica Habblett Clyde Valentine Patti Nelson Lucinda Stroud Dave Boyce Robert Jones Elvis Platini Jo Shearer Daniel Goetsch Ryan Noble Eva Schmid David Smith KEISUKE MUROI Chris Dardi Uthpala Weerasena Brandon Rothe Moti Ben Moshe Layth Habeeb Manuel Conde Joshua Smith Nathalie Sabatier Luis Arturo De la Riva Lujan Mike Lippman Kyle Lind Zainab Jahad Matthew Lamkin Colleen Wolf Adam Coombs Nicola Gulli Cédric Mathys Jason Tian Shogo Yamane Hayley Holloway Brenda Zimmerman Pedro Arteca Robin Haywood Prathyush Reddy Guttha Caleb Figgers Scott Grotz Jake Cropton George Belton Ashish Pattni Diego Rodriguez Sami Marzouki Krzysztof Pienkowski Oliver Brückner Nadine Kaiser Alexander Brendecke Mathew Khan kazuhisa honda Jonathan Horlings Joshua Kace Donald Johnson Alex Polatsky Laura Ede Mike Sheehan Sam Haidar Marissa Wheeler Kristin Callens May Lee Jade Foerster Brian Chen Megan Moorehead Casey Jordan Tanya Schwartz Mike Rand Elene Saakashvili Nicholas Miller Jaime Rodriguez Ed Castillo Seth Wilson Vance Lopez Matt Hall Michael Easter Anthony Trinh Arya Guha Service Desk Enio Belo Csaba Kafka Christopher Whitten Barry Vargo Gary Steward Kate Dubay Francisco Egido Arnaud MARCEL Admin BE Santiago Cacho Chris Louder Derek Pargeter Gabriele Ballarin Giulia Mosca 晃範 小野 Satoshi Hotta Francis Hew 英希 梅原 Pam Miller Justiniano Dante Quirino Mildred Camaya Jean Edlagan Dylan Tompkins Ashley Ames Naoki Matsumoto Ryan Jerving Almir Junior Kenandy Support Jared Reid Paulo Uchôa Tihomir Nedyalkov Robert Chang Jack Smith Christian Zimmer Patricia Romano Jerod Galvin Jason Long Kévin Tumen TJ Sexton Andy McCornack David Mayotte Rick Martin Heather Kanabay Seth Ream Caleb Contente Selvyn Alves Charles Nelson Danielle Dornan Michelle Ferrier Nader Bayani Michelle Bingham Mona Shaw Andrea Catena Lisa B Nathan Fernandez aPriori IT Marc Brady J Brookes Paulina Cajiao Vítor Antunes Curtis Mathers Andy Harding Daniel Lowery Suhana Sonny Monica Barrios Tim Connor Emma Prong Satwinder Randhawa Anamika Rathore Jandu David BOTELLA Hannah Johnson Kristine Vargas Eli Lavarias Bill Wiest Jeannine Flynn Christophe Lelandais Daniel Marcus Timo Kastner Marvin Reymers Release Manager PJ Sweeney Sean Lee Thiago Kobayashi Rob van der Leer Henri Weber Derrick Tesson Chai Kanchan Robert Woolley Danielle Wright Lisa Müller John Stelling Yvonne Taylor Jodie Davey Thibault CHEVALIER Biaf Chalabi Andres Felipe ARANGO Andrew Ellis Sebastian Schulz Brett Phillips Jean Leyh Jobright Peter Finn Scott Rebecca Wyatt Natasha Leverton Deborah Rothwell Ross Barlow Fletcher King Pascal Quintin Maximilian Messerschmidt Stuart Knipe Andreas Steinhauser Michal Skara Alain Hollenthoner Hana Celbova Stephen Matthee Nevena Nikolic 由浩 松浦 Irina Clington Manish Y Cliff Lindberg Aaron Aab Felipe Castellani Elliot May Mavarik Arthur Waclaw Bukowski Malcolm Douglas Trevor Wong Camilla Antunes Silva Eric Hansen Sven Simon Mohamed Edah Kamal Zia Pam Merkle Madelene Wärja Wim van Strien Miloš Novaković Stéphane MONTBRIZON Bettina Guter Ern-ling Lim SW Finance Yuri Garcia Caetano Gary Somerville Jamal Abdullah Anit Sharma Paul McCollum Enrico Fantini Bryan Kleparek Krishna Kodali Jason Bell Georg Wenk Tim Klimasewski Gabriel Harr John Ackland Anthony Angeline Austin Steiner Bill Hanson Ruth Karagacha Jennifer Godreau Ruth Karagacha Matt Auer Marshall Weakley Kirill Yunussov Joseph Desch Leslie Wright Travis Suzuki Christy Qualle Ryann Todd Karl Beck Christopher Viramontes HuiJane Li Thomas Krolak Charles Miller Andrew Kinney Brandon Jefferson Ken Gertler Ken Prewett Jake Philbrook Nate Ziegler Dave Nelson Tricia Ford Selvyn Guimaraes Alves Marco van Creij Jody Lawson David Guingnier Adam Kruczek Vicki Harrell Aaron Van Tassel Hal Elrod Yvan Luna Steven Leong Sravanthi Yarava Chris Torres Immanuel Wolff Erik Nelke Patrick Craven Derrick Taylor David Tracy Savident Prakash Dandapani (MCS) Janice Mackedon

Is it Fixed?

AP0 AP3 AP4 AP5 AP6 AP7 AP8 AP9 AP10 AP11 AP12 AP13 AP14 AP15 AP16 AP17 AP18 AP19 AP20 AP21 AP22 AP28 CS1 CS2 CS3 CS4 CS5 CS6 CS7 CS8 CS9 CS10 CS109 CS108 CS107 CS106 CS105 CS102 CS101 CS100 CS115 CS119 CS110 CS117 CS114 CS113 CS112 CS111 CS11 CS116 CS12 CS122 CS121 CS126 CS127 CS129 CS128 CS125 CS124 CS123 CS137 CS138 CS13 CS133 CS132 CS14 CS148 CS142 CS159 CS152 CS151 CS15 CS165 CS16 CS169 CS17 CS18 CS194 CS19 CS198 CS196 CS195 CS20 CS21 CS22 CS23 CS24 CS25 CS26 CS27 CS28 CS29 CS30 CS31 CS32 CS33 CS34 CS35 CS36 CS37 CS40 CS41 CS42 CS43 CS44 CS45 CS47 CS50 CS51 CS52 CS53 CS54 CS57 CS58 CS59 CS60 CS61 CS62 CS63 CS64 CS65 CS66 CS67 CS68 CS69 CS70 CS71 CS72 CS73 CS74 CS75 CS76 CS77 CS78 CS79 CS80 CS81 CS82 CS83 CS84 CS85 CS86 CS87 CS88 CS89 CS90 CS91 CS92 CS94 CS95 CS96 CS97 CS98 CS99 EU7 EU8 EU10 EU12 EU13 EU14 EU15 EU16 EU17 EU18 EU19 EU25 EU26 EU27 EU28 EU29 EU30 EU31 EU32 NA104 NA107 NA109 NA100 NA101 NA103 NA102 NA105 NA119 NA116 NA110 NA118 NA112 NA111 NA115 NA114 NA113 NA117 NA125 NA124 NA122 NA120 NA126 NA127 NA123 NA129 NA121 NA128 NA138 NA134 NA133 NA136 NA135 NA132 NA131 NA130 NA137 NA139 NA140 NA142 NA141 NA146 NA147 NA148 NA154 NA155 NA172 NA174 NA171 NA173 NA196 NA21 NA46 NA47 NA49 NA52 NA54 NA57 NA58 NA59 NA61 NA62 NA64 NA65 NA66 NA67 NA68 NA69 NA70 NA71 NA72 NA73 NA74 NA75 NA76 NA77 NA79 NA80 NA81 NA82 NA83 NA84 NA85 NA86 NA87 NA88 NA89 NA90 NA91 NA92 NA93 NA94 NA95 NA96 NA97 NA98 NA99 UM1 UM2 UM3 UM4 UM5 UM6 UM7

Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.