Excel Performance Problems

Fix Excel Freezing When Pasting Large Amounts of Data

Aamir Naveed AkramAamir Naveed Akram Nov 18, 2026 870 views

Question details

The user needs to paste a large amount of website data into Excel without the application freezing.

Fix Excel Freezing When Pasting Large Amounts of Data
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.
Before you start

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.

Solution 1Recommended

Import Website Data Instead of Pasting It

Use Excel's data import tools when the website provides a table or downloadable data file.

1
Open the import tool

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.

2
Select the source

Enter the website URL or select the downloaded file, then choose the table or data you want in the Navigator window.

3
Load the data

Select Load to import the data into a worksheet, or choose Transform Data to review and adjust it before loading.

Import Website Data Instead of Pasting It
Website access: Some websites require sign-in or use dynamic content that Excel's web connector cannot import directly. If necessary, download a CSV file from the site or try pasting in smaller batches.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS filesWork with rows of spreadsheet data in a familiar interfaceMove existing Office documents into a compatible workspaceUse a free, lightweight office suite
QA img-9

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.