Document Editing Problems

Fix Excel Copying a Worksheet to a Blank Workbook Error

Aamir Naveed Akram Oct 23, 2026 868 views

Question details

Excel sometimes fails to transfer data and instead creates a completely blank workbook when a user attempts to copy a worksheet.

How to Fix Excel Copying a Worksheet to a Blank Workbook

Product: Microsoft Excel
Device & OS: Windows
Scenario: Duplicating or transferring a worksheet from an existing file to a new workbook.
Observed behavior: Excel generates a blank 'Book1' workbook rather than successfully copying the selected worksheet's content.

Before you start

Ensure that your source workbook is fully saved to your local drive before attempting to move or copy any worksheets.

Solution 1Recommended

Verify File Format and Standard Copy Procedure

Ensure you are using the correct context menu method and check if the issue is isolated to a specific file format like XLSM.

Intermittent worksheet copying issues are often tied to specific file formats, particularly macro-enabled workbooks. Verifying the correct procedure can resolve temporary glitches.

Initiate copy

Right-click the worksheet tab you want to duplicate at the bottom of your Excel window.

Select Move or Copy

Click 'Move or Copy' from the context menu to open the dialog box.

Configure destination

In the 'To book' dropdown menu, choose '(new book)', ensure 'Create a copy' is checked, and click OK.

Verify file format

Check whether the source file is saved as an XLSX or XLSM format. If it is XLSM, try saving a copy as XLSX and repeating the process.

Format Constraints: Macro-enabled (XLSM) files sometimes restrict copying worksheets to standard XLSX workbooks due to macro security protocols.

Solution 2

Run Excel in Safe Mode

Safe Mode loads Excel without third-party add-ins, helping identify if a faulty extension is causing the blank workbook error.

Solution 3

Perform a Clean Boot and Update Office

If the issue affects all workbooks, a background program might be interfering, or your Office installation may need an update.

Free Microsoft Office alternative

Use WPS Spreadsheet to Avoid Worksheet Copying Errors

Tired of unpredictable Excel errors when copying worksheets? Switch to WPS Office, a highly compatible, lightweight, and free alternative that handles your spreadsheet tasks seamlessly without generating blank files.

1. Download and Install: Get WPS Office for free from the official website and install it on your device in minutes.
2. Open Your Workbook: Launch WPS Spreadsheet and open your existing XLSX or XLSM file without losing any formatting or data.
3. Copy Worksheets Flawlessly: Right-click the sheet tab and easily copy or move it to a new workbook without encountering blank page errors.

Perfectly compatible with Microsoft Excel formats including .xlsx, .xlsm, and .xls.Lightweight installation with incredibly fast startup and processing times.Familiar tabbed user interface, ensuring a zero learning curve for Excel users.Free to download and use for all your essential spreadsheet needs.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel create a blank Book1 when copying a worksheet?

This error can occur due to corrupt source files, incompatible macro elements in XLSM files, outdated Office versions, or interference from third-party Excel add-ins.

Does the file format (XLSX vs XLSM) affect copying worksheets?

Yes, macro-enabled workbooks (XLSM) sometimes encounter copying restrictions or cause intermittent errors when transferring a worksheet to a new, standard XLSX workbook.

How do I run Excel in Safe Mode to check for add-in conflicts?

Press the Windows Key + R, type 'excel /safe', and hit Enter. This launches Excel with all add-ins disabled, allowing you to test if an extension is causing the worksheet copy failure.

Document & File Issues