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 copying data from portal and pasting in my sheet then it getting hand i dont know why excel handing with less data.
Current version of my excel is 2208
Please help me on this.
10 Replies
- In my case for some reason every time I copy-paste Excel tries to access the default printer. It took me a long time to realize there was a little notification on the left bottom corner. After changing the default printer to "Microsoft Print to PDF" Excel stopped freezing.
- You are amazing!, it was frustrating to copy, paste and freeze, thank you!
jhrecife I was surprised to find the same cause after reading this (THANKS!).
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.
Hello,
There could be several reasons why your Excel sheet is getting slow when you are copying data from a website. Here are some possible solutions:
Turn off automatic calculation: By default, Excel calculates formulas automatically. This can slow down the performance of your worksheet. To turn off automatic calculation, go to the "Formulas" tab, click "Calculation Options," and select "Manual."
Use Excel's data import feature: Instead of copying and pasting data manually, you can use Excel's data import feature to import data directly from the website. Go to the "Data" tab, click "Get Data," and select the appropriate data source. This will help you to import data more efficiently and avoid any issues with slow performance.
Clear the clipboard: When you copy data in Excel, it is stored in the clipboard. If you have a large amount of data in your clipboard, it can slow down the performance of Excel. To clear the clipboard, go to the "Home" tab, click the drop-down arrow next to "Clipboard," and select "Clear All."
Check for formatting issues: Conditional formatting can slow down Excel if it is applied to a large range of cells. Make sure that you are only applying conditional formatting to the cells that you need. Additionally, check for any other formatting issues in your worksheet, such as excessive cell borders or unnecessary styles.
Close other programs: Running multiple programs at the same time can slow down your computer and cause Excel to perform poorly. Close any unnecessary programs and try running Excel again to see if this improves performance.
Upgrade your hardware: If you are working with large amounts of data, you may need to upgrade your computer's hardware to improve performance. Consider adding more RAM or upgrading to a faster processor to help Excel run more smoothly.
