File Corruption & Recovery

Fix Excel Chart Worksheet Tab Names Changed to Chart1 and Chart2

Maira Mehtab Sep 22, 2026 868 views

Question details

Users find that their customized Excel chart worksheet tab names have unexpectedly changed back to default generic names such as Chart1 and Chart2.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Opening an Excel workbook after a system crash, file corruption, or when an earlier version of the file replaces the current one.
Observed behavior: The custom names assigned to chart sheets are lost and replaced by Excel's default naming convention (Chart1, Chart2, etc.).

Before you start

Confirm whether you are working in Excel for the Web or the Excel Desktop application, and check your computer's local backup or version history settings to see if file recovery is enabled.

Solution 1Recommended

Restore a Previous Version of the Workbook

If the workbook is corrupted or was replaced by an older version, restoring a recent, uncorrupted backup is the most reliable way to recover your custom tab names.

File corruption can sometimes strip custom metadata like worksheet names. Restoring a healthy previous version prevents the need to manually recreate your work.

Access Version History

If you are using OneDrive or SharePoint, open the file in Excel, click on the file title at the top of the window, and select 'Version History'.

Locate the Correct Version

Review the list of previous versions in the right-hand pane. Click 'Open version' on a timestamp from before the corruption occurred.

Verify and Restore

Check the chart tabs at the bottom of the screen to confirm the custom names are present, then click the 'Restore' button at the top of the document to make it the active version.

Mac Users: If you are using a Mac and save files locally, you may be able to recover an older version containing the correct tab names using the macOS Time Machine application.

Solution 2

Manually Rename the Chart Tabs in the Recovered File

If no backup or previous version is available, you will need to continue working with the recovered file and manually restore the tab names.

WPS Spreadsheet Solution

Manage and Rename Chart Sheets Easily with WPS Office

WPS Office provides a highly stable spreadsheet environment, allowing you to easily open recovered Excel workbooks, manually rename chart tabs, and save your documents securely without the risk of further corruption.

1. Open the Workbook in WPS: Launch WPS Office, select 'Spreadsheet', and open your recovered Excel file.
2. Rename the Chart Tabs: Double-click the generic 'Chart1' or 'Chart2' tab at the bottom of the workspace and type your custom name.
3. Save Securely: Click 'Menu' in the top-left corner, select 'Save As', and save your document to ensure all new names are locked in safely.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Stable file recovery and local backup features to prevent data lossFree, lightweight, and fast alternative for everyday spreadsheet tasks

microsoft office alternative - wps office

Frequently Asked Questions

Why did my Excel chart tab names suddenly change to Chart1 and Chart2?

This usually happens due to workbook corruption or a synchronization conflict where a newer, damaged version of the file replaces the original. When Excel attempts to recover a corrupted file, it may strip out unreadable custom metadata and revert to default names.

Can I recover my custom tab names without a backup file?

If you do not have a previous version saved in OneDrive, SharePoint, or Time Machine, the custom names cannot be automatically restored. You will need to manually rename the tabs in the recovered file.

How can I prevent my Excel workbooks from becoming corrupted in the future?

To minimize corruption, ensure AutoSave is enabled if you are using cloud storage, avoid working on large files directly from a network drive with an unstable connection, and keep your spreadsheet software updated to the latest version.

Document & File Issues