Excel Error Codes

How to Fix Excel Error: We Couldn't Copy This Sheet

Khadija Khan Sep 28, 2026 958 views

Question details

The user is attempting to duplicate or move a worksheet but encounters an error preventing the action from completing.

How to Fix Excel Error "We Couldn't Copy This Sheet"

Product: Microsoft Excel
Device & OS: not provided
Scenario: Duplicating a worksheet within the same workbook or moving it to a new workbook that contains complex data, PivotTables, or external links.
Observed behavior: Excel interrupts the copying process and displays the warning message: "We couldn't copy this sheet."

Before you start

Before troubleshooting, save a backup copy of your current workbook to prevent accidental data loss while modifying worksheet connections, features, or protections.

Solution 1Recommended

Manually Copy Cell Contents to a New Sheet

A reliable workaround when built-in sheet duplication fails due to corrupted features, complex formatting, or hidden data.

Instead of copying the worksheet as a whole object, creating a blank sheet and pasting the values and formats bypasses the underlying structural issues that trigger the error.

Create a New Worksheet

Click the '+' icon next to your existing sheet tabs at the bottom of the Excel window to create a new, blank worksheet.

Select All Data in the Original Sheet

Go to the problematic worksheet and click the triangle icon in the top-left corner of the grid (between column A and row 1), or press 'Ctrl + A' to select all cells.

Copy the Data

Press 'Ctrl + C' or right-click the selected area and choose 'Copy'.

Paste into the New Sheet

Navigate to the new blank worksheet, select cell A1, and press 'Ctrl + V' to paste the content. Adjust column widths if necessary.

Manually Copy Cell Contents to a New Sheet

Tip: To preserve your column widths and specific formatting, use 'Paste Special' > 'Keep Source Column Widths' after pasting the main data.

Solution 2

Use the 'Move or Copy' Feature Properly

Ensures that the correct system method is used to duplicate the sheet, rather than relying on drag-and-drop shortcuts which can sometimes glitch.

Solution 3

Remove Protection and Check for Complex Data Connections

Worksheet protection, PivotTables, Power Query connections, or hidden external links can block Excel from duplicating a sheet.

Duplicate Sheets Effortlessly

How to Copy Worksheets Seamlessly in WPS Office

WPS Office provides a streamlined, lightweight spreadsheet application that avoids common heavy-data copying errors. You can easily duplicate your complex worksheets without experiencing the 'couldn't copy this sheet' error.

1. Open Your Workbook in WPS: Launch WPS Office and open your existing spreadsheet file.
2. Right-Click the Sheet Tab: Locate the worksheet tab at the bottom of the screen and right-click it to open the context menu.
3. Select Move or Copy: Choose the 'Move or Copy' option from the list.
4. Create a Copy: Check the 'Create a copy' box, choose your destination, and click 'OK' to instantly duplicate the sheet.

Highly compatible with Microsoft Excel (.xlsx, .xls) file formats.Optimized memory usage for handling large datasets and complex formulas without crashing.Quick, intuitive, and error-free worksheet duplication tools.

microsoft office alternative - wps office

Frequently Asked Questions

Does low available memory cause the 'We couldn't copy this sheet' error?

Not always. While the error message or related prompts might suggest a memory issue, this error is most commonly caused by workbook corruption, complex PivotTables, Power Query connections, or protected content within the sheet.

How can I copy an Excel sheet if it contains Power Query connections?

Power Query connections can complicate worksheet duplication. It is often better to duplicate the query directly from the 'Queries & Connections' pane, or manually copy only the resulting data values into a new, blank sheet.

What should I do if the error persists across all my Excel files?

If you encounter this error in every workbook, the Excel application itself might be corrupted or experiencing add-in conflicts. Try launching Excel in Safe Mode (hold the Ctrl key while opening Excel). If the issue persists, use the 'Repair' tool for Microsoft 365 from your Windows Apps settings.

Microsoft Office Error Codes