File Corruption & Recovery

Fix an Excel Workbook That Becomes Corrupt After Renaming

Elise WilliamsElise Williams Nov 14, 2026 868 views

Question details

The user needs to recover an Excel workbook that opens under its original name but appears corrupt after being renamed.

Fix an Excel Workbook That Appears Corrupt After Renaming
Product
Microsoft Excel
Device & OS
not provided
Scenario
Rename an existing Excel workbook and open it under the new name.
Observed behavior
The workbook opens normally with its original name but appears corrupt after the name is changed.
Before you start

Open the workbook under its original name and note its file extension, such as .xlsx or .xlsm. Check whether it is stored in a synced folder or a location where you may not have permission to rename files.

Solution 1Recommended

Copy the Worksheets to a New Excel Workbook

Use this approach when the original workbook opens but its renamed version does not.

1
Open the original workbook

In Excel, select File > Open and open the workbook using its original name.

2
Copy the worksheets

Right-click a sheet tab, choose Select All Sheets, then right-click a selected tab and choose Move or Copy. Select (new book), check Create a copy, and select OK.

3
Save the new workbook

In the new workbook, select File > Save As and give it a different name. Choose the appropriate file type, such as .xlsx or .xlsm for a macro-enabled workbook.

4
Test the new file

Close the new workbook, rename it without changing its extension, and open it again. Check its formulas, links, formatting, and any macros.

Copy the Worksheets to a New Excel Workbook
Check workbook-level features: Copying worksheets may not preserve every workbook-level setting, connection, or macro. Verify these features in the new file.
Repair your workbook workflow

Rebuild the Workbook in WPS Spreadsheet

Use WPS Spreadsheet to open the original workbook, copy its sheets into a new workbook, and test the renamed file.

  1. 1. Open the original file: Launch WPS Spreadsheet and use Open to select the workbook with its original name.
  2. 2. Create a destination workbook: Select New to create a blank spreadsheet while keeping the original workbook open.
  3. 3. Copy the sheets: In the original workbook, right-click a sheet tab and choose Move or Copy. Select the new workbook as the destination, choose to create a copy, and repeat for the remaining sheets.
  4. 4. Save and test: In the new workbook, select File > Save As and choose an appropriate Excel format. Close the file, rename it without changing its extension, and reopen it to check its contents.
Copy worksheets into a new workbook to test whether renaming worksOpen and save Microsoft Excel formats, including .xlsx and .xlsmUse familiar sheet tabs and file-saving controls
microsoft office alternative - wps office

Frequently Asked Questions

Can changing an Excel file extension make it appear corrupt?

Yes. Changing or removing the extension during a rename can cause the file to be opened incorrectly. Check the original extension in your file manager and keep it when renaming.

How do I copy all sheets into a new workbook in Excel?

Right-click a sheet tab, choose Select All Sheets, then right-click a selected tab and choose Move or Copy. Select (new book), check Create a copy, and select OK.

Where is Open and Repair in Excel?

Select File > Open > Browse, select the affected workbook, then select the arrow next to Open and choose Open and Repair.

Will copying sheets preserve macros and external connections?

Not necessarily. Check macros, connections, named ranges, and other workbook-level features in the new file. If the workbook contains macros, use a macro-enabled format such as .xlsm when saving.