Document Editing Problems

Fix Excel for the Web Copy Errors When Selecting Multiple Items

WPS Content Manager Sep 30, 2026 869 views

Question details

Users encounter an error preventing them from copying multiple selected items or large data ranges between worksheets in the web version of Excel.

How to Fix Errors When Copying Multiple Items in Excel for the Web

Product: Excel for the Web
Device & OS: not provided
Scenario: Attempting to copy a large selection of items or entire worksheet data between sheets using an Excel file stored on OneDrive.
Observed behavior: The copy action fails to execute, often triggering an error message due to the strict clipboard and feature limitations present in Excel for the web.

Before you start

Ensure your browser is updated to the latest version and verify that your OneDrive file synchronization is fully completed before attempting to transfer data.

Solution 1Recommended

Divide Data into Smaller Groups for Copying

Because Excel for the web has strict browser-based clipboard limits, manually dividing your data into smaller column chunks prevents copy failures.

Excel for the web operates within a browser environment, which allocates fewer system resources and imposes tighter feature limitations compared to the desktop application. When you attempt to copy an extensive range, the memory limit is quickly reached.

Select a smaller range

Highlight a reduced set of columns, for example, columns A through N, instead of selecting the entire worksheet.

Copy the selection

Right-click the highlighted area and select 'Copy', or press Ctrl+C (Cmd+C on Mac) on your keyboard.

Paste into destination

Navigate to the target worksheet, select the starting cell, and press Ctrl+V (Cmd+V) to paste.

Repeat for remaining data

Go back to the original sheet and select the next group of columns (e.g., columns O through AB). Copy and paste them into the destination sheet, repeating this process until all data is transferred.

Divide Data into Smaller Groups for Copying

Browser Limitations: This issue is specific to Microsoft 365 OneDrive files opened in the web browser. The desktop version handles large clipboards seamlessly.

Solution 2

Open the Workbook in the Desktop Application

Switching from the web interface to the desktop application bypasses browser clipboard limits and restores full copying functionality.

Free Microsoft Office alternative

Bypass Web Limitations with WPS Office Desktop App

If you are frustrated by the clipboard limits and feature restrictions of Excel for the web, consider switching to WPS Office. It provides a robust, fully-featured desktop experience that effortlessly handles large data transfers, entirely for free.

Fully compatible with Microsoft Excel (.xlsx, .xls) filesPowerful desktop clipboard supporting massive data transfers without crashingFree and lightweight software that runs smoothly on most computersFamiliar spreadsheet interface that requires zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does copying work in desktop Excel but fail in the web version?

Excel for the web operates within an internet browser, which limits the amount of memory and clipboard size a single webpage can use to prevent the browser from crashing. The desktop application has direct access to your computer's full system resources, allowing for much larger data transfers.

Is there a specific cell limit when copying in Excel for the web?

While Microsoft does not publish a static hard limit, attempting to copy more than 10,000 cells or selecting multiple non-adjacent items across a large range typically triggers a memory limitation error in the web environment.

Can I permanently increase the copy limit in Excel for the web?

No, the copy limitation is built into the architecture of the web application. To resolve it, you must either divide your data into smaller batches (such as copying columns A to N, then O to AB) or open the document in a desktop spreadsheet application.

Document & File Issues