Fix Excel Freezing When Pasting Large Amounts of Data
Question details
The user needs to paste a large amount of website data into Excel without the application freezing.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Pasting website data into a worksheet containing approximately 30,000 records.
- Observed behavior
- Excel may freeze during the paste operation.
Check whether the website data is available as a structured table or downloadable file. Note any formulas and conditional formatting in the destination range so you can test their effect on performance.
Import Website Data Instead of Pasting It
Use Excel's data import tools when the website provides a table or downloadable data file.
In Excel, select the Data tab, then choose Get Data and look for the appropriate source, such as From Web or From Text/CSV. Menu names vary by Excel version.
Enter the website URL or select the downloaded file, then choose the table or data you want in the Navigator window.
Select Load to import the data into a worksheet, or choose Transform Data to review and adjust it before loading.

Reduce the Work Excel Does During a Paste
Test calculation, clipboard contents, conditional formatting, and batch size if you need to paste the data.
Test Whether the Default Printer Is Delaying Excel
On Windows, try another default printer if Excel appears to wait for printer communication during copying or pasting.
Work With Excel Data in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility for moving existing files. It does not fix freezing in Microsoft Excel.

Frequently Asked Questions
Why does Excel freeze when I paste website data?
Large pastes can trigger recalculation or complex formatting, use substantial system resources, or encounter a printer communication delay. Try importing through Data > Get Data or test the other causes one at a time.
How do I turn automatic calculation back on?
In Excel, select Formulas > Calculation Options > Automatic. If you are still using manual calculation, press F9 to recalculate formulas.
Is there a fixed limit on copying conditionally formatted cells?
There is no specific copy-and-paste limit for conditionally formatted cells, but complex rules across large ranges can slow Excel. Review them under Home > Conditional Formatting > Manage Rules.
Can a default printer make Excel freeze during a paste?
Printer communication can cause delays in some cases. On Windows, try setting Microsoft Print to PDF or another available printer as the default in Settings > Printers & scanners, then repeat the paste.
What if Excel cannot import the website table?
Check whether the website offers a CSV download and import it through Data > Get Data > From Text/CSV. Otherwise, try copying and pasting smaller batches.




