Excel Performance Problems

Fix Excel Taking 30 Minutes to Copy or Drag a Large Worksheet

Maira Mehtab Sep 22, 2026 869 views

Question details

The user experiences a 30-minute delay when trying to copy or drag a worksheet in a 24 MB Excel workbook.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Duplicating or moving a worksheet that contains dense INDEX/MATCH formulas within a large workbook.
Observed behavior: Excel freezes or takes up to 30 minutes to complete the worksheet duplication, despite automatic calculation being disabled and having no external links.

Before you start

Create a simplified test copy of your workbook by deleting several background sheets to check if the issue is isolated to specific worksheet data or global formula density.

Solution 1Recommended

Optimize Complex Formulas and Data Ranges

Reduce formula complexity and range sizes to prevent Excel's calculation engine from bottlenecking during sheet duplication.

Even with automatic calculation turned off, Excel's background memory management can struggle with copying millions of cells containing dense INDEX/MATCH formulas.

Limit Array Ranges

Select your formula cells and modify the references to target specific ranges (e.g., A1:A1000) instead of referencing entire columns (e.g., A:A) within your INDEX/MATCH formulas.

Convert Formulas to Static Values

Highlight historical data that no longer needs active calculation, press Ctrl+C to copy, right-click, and select 'Paste Special > Values' to remove the underlying formulas.

Split Large Data Areas

Divide exceptionally large data sets into smaller, separate worksheets to reduce the metadata processing load required when moving a single sheet.

Performance Boost: Converting heavy lookup formulas to static values is often the fastest way to instantly restore worksheet responsiveness.

Solution 2

Utilize Power Query for Data Merging

Offload heavy data processing from worksheet formulas to Power Query, which handles large datasets much more efficiently.

Solution 3

Update Excel to the Latest Build

Ensure your Excel application is fully updated to leverage the latest performance optimizations and background architecture improvements.

Free Microsoft Office alternative

Experience Faster Worksheet Processing with WPS Office

If Microsoft Excel continues to lag or freeze when handling large workbooks, try WPS Office. It provides a lightweight, highly efficient architecture designed to process heavy spreadsheets smoothly without sacrificing features. Enjoy seamless migration with a familiar interface and zero cost.

1. Install WPS Office: Download and install the free version of WPS Office from the official website.
2. Open Your Large Workbook: Launch WPS Spreadsheet and click 'Open' to load your heavy .xlsx file.
3. Manage Worksheets Smoothly: Right-click the worksheet tab and select 'Move or Copy' to experience faster sheet duplication.

Highly optimized architecture for faster copying and moving of large worksheets.Fully compatible with Microsoft Office spreadsheet formats (.xlsx, .xls, .csv).Lightweight installation that consumes significantly fewer system resources.Familiar user interface with a virtually zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel lag when copying a sheet even with automatic calculation disabled?

Even with calculation disabled, Excel must duplicate the dependency tree, formatting metadata, and defined names for all cells in the worksheet. If the sheet contains dense lookup formulas across thousands of rows, the sheer memory allocation required causes significant delays.

Can external links cause a worksheet to copy slowly?

Yes. If a worksheet contains links to other external workbooks, Excel attempts to verify and map those connection paths during the duplication process, which drastically increases the time it takes to structural changes to the file.

Is there a limit to how large an Excel workbook can be before performance drops?

While Excel's physical file size limit is dictated by your system's available RAM, files exceeding 20 MB that contain complex arrays, conditional formatting, or dense lookup functions frequently experience severe performance degradation during structural operations like copying or moving sheets.

Excel & Data Problems