Fix an Excel Workbook That Becomes Corrupt After Renaming
Question details
The user needs to recover an Excel workbook that opens under its original name but appears corrupt after being renamed.

- 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.
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.
Copy the Worksheets to a New Excel Workbook
Use this approach when the original workbook opens but its renamed version does not.
In Excel, select File > Open and open the workbook using its original name.
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.
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.
Close the new workbook, rename it without changing its extension, and open it again. Check its formulas, links, formatting, and any macros.

Check the Extension and Storage Location
Use these checks if the new workbook also fails after renaming.
Use Excel Open and Repair
Try Excel's repair tool if the renamed file still reports corruption with the correct extension.
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. Open the original file: Launch WPS Spreadsheet and use Open to select the workbook with its original name.
- 2. Create a destination workbook: Select New to create a blank spreadsheet while keeping the original workbook open.
- 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. 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.

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.




