Excel Performance Problems

How to Fix Excel Data Too Large Error in Microsoft 365

Adam Davis Sep 25, 2026 872 views

Question details

The user is unable to copy a large dataset containing one-minute readings for an entire year into Excel due to a data size error.

How to Fix Excel Data Too Large Error in Microsoft 365

Product: Microsoft 365 Family
Device & OS: not provided
Scenario: Attempting to paste or transfer a massive dataset containing 2024 one-minute interval readings into an Excel workbook.
Observed behavior: Excel blocks the operation and triggers a 'data too large' error message, preventing the dataset from being copied into the file.

Before you start

Before troubleshooting, observe exactly when the error occurs (e.g., while pasting into a worksheet, uploading to OneDrive, or opening the file) and record the exact error message to narrow down the root cause.

Solution 1Recommended

Use Power Query and the Excel Data Model

Power Query is the most reliable method for importing large datasets without triggering clipboard or grid size errors.

Copying and pasting massive datasets consumes a significant amount of system memory and often triggers limitations within the Windows clipboard or Excel's grid. Using Power Query bypasses the clipboard entirely and can handle millions of rows by loading them directly into the Data Model.

Open the Data tab

Launch Microsoft Excel and create a blank workbook. Navigate to the 'Data' tab on the top ribbon.

Import the dataset

Click on 'Get Data', select 'From File', and then choose 'From Text/CSV' or 'From Excel Workbook' depending on your source data format.

Load to Data Model

In the preview window, click the arrow next to 'Load' and select 'Load To...'. Choose 'Only Create Connection' and check the box for 'Add this data to the Data Model', then click OK.

Use Power Query and the Excel Data Model

Data Modeling Advantage: Adding data to the Data Model allows you to create PivotTables and run analytics on datasets that exceed Excel's physical 1,048,576 row limit.

Solution 2

Split the Dataset Across Multiple Worksheets

Divide your yearly data into smaller chunks (e.g., by month) to ensure it stays well within Excel's physical row and column limitations.

Solution 3

Test with Excel for the Web or a Clean Workbook

Determine if the issue is a local application corruption or a specific file glitch by testing the dataset in a different environment.

Free Microsoft Office alternative

Handle Extensive Datasets Seamlessly with WPS Office

If Microsoft Excel continues to struggle with clipboard crashes or 'data too large' errors, WPS Office provides a highly optimized, lightweight alternative. It processes large files efficiently and operates with a familiar interface, completely free of charge.

1. Download and Install: Visit the official WPS Office website and download the free installation package for your operating system.
2. Open WPS Spreadsheet: Launch the WPS Office application and click on 'Spreadsheet' to start a new workspace.
3. Import Your Data: Go to 'Menu' > 'Open' to select and load your large dataset effortlessly.

Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csvLightweight system architecture designed for smooth performance with large datasetsFree to use with a highly familiar user interface that requires zero learning curveExcellent memory management to help avoid clipboard freezing when copying massive ranges

microsoft office alternative - wps office

Frequently Asked Questions

What is the maximum number of rows and columns Microsoft Excel can handle?

Microsoft Excel has a strict limit of 1,048,576 rows and 16,384 columns per worksheet. If your data exceeds these dimensions, you will receive an error and should use the Data Model or split the file.

Why do I get a 'data too large' error if my data is under the row limit?

This error often occurs due to system RAM limitations or Windows clipboard restrictions when you attempt to copy and paste hundreds of thousands of rows simultaneously. Using the 'Get Data' feature avoids clipboard limitations.

Can I increase the physical row limit in Excel?

No, the grid limits (1,048,576 rows by 16,384 columns) are hardcoded into the application and cannot be increased. For larger analytics, you must use Power Query and Power Pivot.

Is there a way to clear the clipboard to prevent Excel from crashing?

Yes. In Windows, you can press the Windows Key + V to open the clipboard history panel and click 'Clear all' to free up memory before attempting another large data transfer.

Excel & Data Problems