I have had a frequent problem in Excel 2013 and Excel 2010 on several different computers, where Excel would freeze for 10-20 seconds when I copied a few cells into 3 or more locations.
I frequently want to copy data into every other row, so I end up hitting paste repeatedly on the same set of copied data, until Excel freezes and I have to wait for it.
I'm hoping someone else has encountered this same problem and has a workaround or solution for this, as when I have to fill in a hundred columns of data this really slows me down.
I've had this problem on three different computers, in both Office Excel 2013 and Office Excel 2010, so it doesn't seem specific to any particular computer setup.
I've attached an example where Excel froze during a copy, and a list of my addins installed.
3 Answers
Using paste from the clipboard repeatedly may cause performance lag or freezing. To avoid this, use multiple select (Ctrl + Click) to choose all the cells you want the content in, then paste.
Here is additional information which might be helpful as well - What can cause slow copy and paste in Excel?
If the problem continues or gets worse, I'd suggest a repair install of Office.
That is possible if you work with a large workbook and the Calculation setting is set to Automatic. Please try to temporarily switch to the manual mode (Options->formulas-> workbook calculation -> manual) and paste again.
If it doesn’t help, you need to define if the cause of the issue is the workbook or Excel/PC. Try to copy and paste in a new workbook. If it works, look into the problematic book – VBA macro, many conditional formatting rules, links to other workbooks...
2I tried 20 suggested solutions from all types of forums, but none worked.
Then it occurred to me that the only "treatment" these cells had was "Conditional Formatting"
I cleared the conditions (Conditional Formatting / Clear Rules / Clear Rules from Selected Cells) and it worked. I even reinstated the original rule and it still works :)
