Forum Discussion
Excel keeps hang while data copy and paste
Hi Team Everyday i am copying data from site and paste in my excel sheet. In my excel sheet it contains around 30000 data and am using only duplicate conditional formatting But still when i am copy...
If I may add... There is no specific limit to the number of conditionally formatted cells you can copy and paste at one time in Excel.
However, be aware that copying and pasting a large number of cells with complex conditional formatting rules can affect Excel's performance.
Because of performance issues, you may want to copy and paste the cells in smaller batches.
You could also try tweaking your conditional formatting rules to improve performance.
Otherwise I know of no automatic solution that could make everything faster.
NikolinoDEI have to add to this.
My hardware is top notch, and I open a new workbook. The behavior is still the same. Frankly, on a laptop with less hardware, I get better results.