Forum Discussion

Leroy Gutierrez's avatar
Leroy Gutierrez
Copper Contributor
Sep 22, 2021
Solved

Excel 2019 freezes when when pasting embedded URL

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? 

  • Leroy Gutierrez's avatar
    Leroy Gutierrez
    Sep 28, 2021
    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.

7 Replies

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    No idea what is wrong, but have you tried a repair of your Office installation?
    • Leroy Gutierrez's avatar
      Leroy Gutierrez
      Copper Contributor

      JKPieterse 
      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...

      • JKPieterse's avatar
        JKPieterse
        Silver Contributor
        Me neither I'm afraid. Any links in range names? Those often cause a file to open slowly

Resources