SOLVED

Excel 2019 freezes when when pasting embedded URL

%3CLINGO-SUB%20id%3D%22lingo-sub-2775848%22%20slang%3D%22en-US%22%3EExcel%202019%20freezes%20when%20when%20pasting%20embedded%20URL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2775848%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%20Team!%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20running%20Office%202019%20(Excel%20v1808%2C%20Build%2010378.20029)%20and%20Win%2010%26nbsp%3B21H1%20(Build%2019043.1237).%20Yesterday%2C%20I%20ran%20a%20manual%20check%20for%20updates%20on%20my%20Office%20suite%2C%20just%20to%20see%20if%20it%20was%20good.%20It%20did%20find%2Finstall%20some%20updates.%20Today%2C%20as%20I%20am%20trying%20to%20paste%20data%20with%20embedded%20URLs%20into%20my%20Excel%20workbook%2C%20I%20am%20seeing%20it%20freeze%20as%20soon%20as%20I%20mouse%20over%20the%20Paste%2Fformat%20options%20(I%20don't%20even%20have%20to%20select%20anything).%20I%20have%20looked%20for%20Add-ins%20(none%20enabled)%2C%20tried%20looking%20at%20Trust%20Center%20settings%20(no%20change%20in%20behavior)%2C%20tested%20the%20copy%2Fpaste%20from%20different%20sources%2C%20and%20even%20tried%20running%20Excel%20in%20Safe%20mode--no%20change.%20Is%20there%20anything%20else%20I%20should%20check%20or%20try%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2775848%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2777469%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202019%20freezes%20when%20when%20pasting%20embedded%20URL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2777469%22%20slang%3D%22en-US%22%3ENo%20idea%20what%20is%20wrong%2C%20but%20have%20you%20tried%20a%20repair%20of%20your%20Office%20installation%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2783487%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202019%20freezes%20when%20when%20pasting%20embedded%20URL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2783487%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EYeah%2C%20before%20I%20posted%20this%2C%20I%20did%20run%20a%20repair%20of%20Office.%20That%20also%20did%20not%20help.%26nbsp%3B%3CBR%20%2F%3EI%20have%20a%20similar%20Excel-related%20issue%20where%20an%20Excel%20spreadsheet%20will%20not%20open.%20I%20found%20that%20if%20the%20hyperlinks%20within%20are%20removed%20(found%20a%20PC%20that%20would%20allow%20the%20spreadsheet%20to%20open)%20then%20the%20file%20opens.%20So%2C%20I%20am%20seeing%20commonality%20with%20the%20hyperlinks%20causing%20Excel%20to%20not%20open.%20Is%20there%20some%20security%20feature%20that%20would%20cause%20this%3F%20I%20am%20not%20aware%20of%20one...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2783649%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202019%20freezes%20when%20when%20pasting%20embedded%20URL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2783649%22%20slang%3D%22en-US%22%3EMe%20neither%20I'm%20afraid.%20Any%20links%20in%20range%20names%3F%20Those%20often%20cause%20a%20file%20to%20open%20slowly%3C%2FLINGO-BODY%3E
New Contributor

Hi there, Team!

I am running Office 2019 (Excel v1808, Build 10378.20029) and Win 10 21H1 (Build 19043.1237). Yesterday, I ran a manual check for updates on my Office suite, just to see if it was good. It did find/install some updates. Today, as I am trying to paste data with embedded URLs into my Excel workbook, I am seeing it freeze as soon as I mouse over the Paste/format options (I don't even have to select anything). I have looked for Add-ins (none enabled), tried looking at Trust Center settings (no change in behavior), tested the copy/paste from different sources, and even tried running Excel in Safe mode--no change. Is there anything else I should check or try? 

7 Replies
No idea what is wrong, but have you tried a repair of your Office installation?

@Jan Karel Pieterse 
Yeah, before I posted this, I did run a repair of Office. That also did not help. 
I have a similar Excel-related issue where an Excel spreadsheet will not open. I found that if the hyperlinks within are removed (found a PC that would allow the spreadsheet to open) then the file opens. So, I am seeing commonality with the hyperlinks causing Excel to not open. Is there some security feature that would cause this? I am not aware of one...

Me neither I'm afraid. Any links in range names? Those often cause a file to open slowly
No... this document really only has email addresses as hyperlinks and "mailto:" hyperlinks in it. Nothing special... and only about 20-25 of them.
In another instance, I am just trying to copy/paste embedded hyperlinks from a web page (I've tried this same operation on different web pages) and as I go to paste, and hover over the formatting of the pasted data, Excel freezes...
Lastly (this is new), I went to Data > Get Data > From File > From Workbook and Excel just freezes up or crashes.
This last error really bothered me, so I closed everything rebooted, ran sfc /scannow and then ran MS Office online repair... Nothing has resulted in a change: Excel still freezes.
best response confirmed by Leroy Gutierrez (New Contributor)
Solution
OK, I believe I have found the issue...
KB5005565 (Security Update for Microsoft Windows) seems to be causing the problem. Once I removed that update, and rebooted, the problem went away. Going to try this fix on the original user's PC tomorrow, and see if that fixes the issue there, too. If it does, then problem solved.
Good catch! I'll report this.

@Leroy Gutierrez Microsoft has confirmed the issue and a fix is on its way. Thanks again for reporting the cause!