Home

Excel stuck at SharePoint sign-in Screen

%3CLINGO-SUB%20id%3D%22lingo-sub-218253%22%20slang%3D%22en-US%22%3EExcel%20stuck%20at%20SharePoint%20sign-in%20Screen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-218253%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI'm%20trying%20to%20extract%20data%20from%20Sharepoint%20in%20excel%20using%26nbsp%3B%22Get%20%26amp%3B%20Transform%20Data%22.%20But%20the%20Sign-in%20page%20for%20the%20SharePoint%20is%20stuck%20is%20not%20letting%20me%20throughout%20the%20site.%20Screenshot%20below.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F38121i551F80890DCBD8FD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222018-07-18_10-53-35.png%22%20title%3D%222018-07-18_10-53-35.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-218253%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-386479%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20stuck%20at%20SharePoint%20sign-in%20Screen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-386479%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F20748%22%20target%3D%22_blank%22%3E%40Anwesh%20Gangula%3C%2FA%3E%26nbsp%3Bhitting%20enter%20worked!%20Thank%20you%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-383423%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20stuck%20at%20SharePoint%20sign-in%20Screen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-383423%22%20slang%3D%22en-US%22%3EA%20simple%20workaround%20is%20to%20click%20enter%20as%20soon%20as%20this%20window%20pops-up.%20Make%20sure%20that%20you%20don't%20click%20anywhere%20else%20or%20on%20any%20other%20window.%20Directly%20hit%20enter%20as%20soon%20as%20this%20window%20pops%20up%20and%20wait%20for%20few%20seconds..%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20that%20doesn't%20work%2C%20Opening%20Excel%20in%20Safe%20mode%20seems%20to%20work%20some%20times.%20But%20I%20haven't%20found%20a%20proper%20solution%20yet.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-362433%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20stuck%20at%20SharePoint%20sign-in%20Screen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-362433%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20happening%20to%20me%20too.%20I%20have%20tried%20clearing%20the%20data%20cache%20and%20logging%20out%20and%20back%20into%20office%2C%20but%20nothing%20seems%20to%20be%20working.%20Did%20you%20find%20a%20solution%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-221974%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20stuck%20at%20SharePoint%20sign-in%20Screen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-221974%22%20slang%3D%22en-US%22%3EIt%20looks%20like%20the%20login%20screen%20was%20open%2C%20but%20it%20was%20not%20being%20displayed%20properly.%20When%20the%20same%20issue%20occurred%20to%20me%20a%20while%20back%20I%20accidentally%20clicked%20enter%20and%20it%20logged%20me%20into%20Sharepoint.%20I'm%20still%20not%20sure%20as%20to%20why%20it%20is%20happening%20and%20it%20is%20still%20happening.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-218685%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20stuck%20at%20SharePoint%20sign-in%20Screen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-218685%22%20slang%3D%22en-US%22%3EYeah%2C%20that%20is%20the%20root%20URL.%20It%20used%20to%20work%20for%20me%20until%20a%20while%20back.%20This%20issue%20has%20started%20recently.%20I'm%20not%20sure%20what%20triggered%20this.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-218449%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20stuck%20at%20SharePoint%20sign-in%20Screen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-218449%22%20slang%3D%22en-US%22%3E%3CP%3EStrange.%20Do%20you%20use%20the%20root%20URL%20of%20your%20SPO%20site%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Anwesh Gangula
Contributor

I'm trying to extract data from Sharepoint in excel using "Get & Transform Data". But the Sign-in page for the SharePoint is stuck is not letting me throughout the site. Screenshot below.

 

2018-07-18_10-53-35.png

6 Replies

Strange. Do you use the root URL of your SPO site?

Yeah, that is the root URL. It used to work for me until a while back. This issue has started recently. I'm not sure what triggered this.
It looks like the login screen was open, but it was not being displayed properly. When the same issue occurred to me a while back I accidentally clicked enter and it logged me into Sharepoint. I'm still not sure as to why it is happening and it is still happening.

This is happening to me too. I have tried clearing the data cache and logging out and back into office, but nothing seems to be working. Did you find a solution?

A simple workaround is to click enter as soon as this window pops-up. Make sure that you don't click anywhere else or on any other window. Directly hit enter as soon as this window pops up and wait for few seconds..

If that doesn't work, Opening Excel in Safe mode seems to work some times. But I haven't found a proper solution yet.

@Anwesh Gangula hitting enter worked! Thank you :)

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies