Fix Excel Chart Sheet Names Resetting After Reopening
Question details
Keep custom Excel chart sheet names after closing and reopening a workbook.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user renames chart sheets and saves the workbook for later use.
- Observed behavior
- Custom chart sheet names revert to names such as Chart1 and Chart2 after the workbook is reopened.
In Excel, rename a chart sheet, save the workbook, and reopen it to confirm the issue. Check whether the same behavior occurs in another workbook to help distinguish a workbook-specific problem from an Office installation issue.
Repair the Microsoft Office installation in Windows
Use Office repair if chart sheet names reset in multiple workbooks or you suspect an installation problem.
Save your open workbooks and close Excel and other Microsoft Office applications.
In Windows, open Settings and select Apps, then Installed apps or Apps & features.
Find Microsoft 365 or Microsoft Office in the app list, select Modify, and choose Quick Repair. Confirm the repair when prompted.
If Quick Repair does not help, return to Modify, choose Online Repair, and follow the prompts. An internet connection is required.
Open the workbook in Excel, rename a chart sheet, save the file, and reopen it to check whether the name remains.

Copy the sheets into a new Excel workbook
Try a new workbook if the issue appears limited to one file or continues after Office repair.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and continue working in WPS Spreadsheets as you migrate; it does not repair the Microsoft Office installation.

Frequently Asked Questions
How do I rename an Excel chart sheet?
Right-click the chart sheet tab, select Rename, enter the new name, and press Enter. Save the workbook before closing it.
Why do my chart sheet names revert after I reopen the file?
The workbook or Office installation may be involved, but the cause is not certain. Test another workbook, then try Office repair or copy the sheets into a new workbook.
Should I use Quick Repair or Online Repair first?
In Windows Settings, select Microsoft 365 or Office under Apps and choose Modify. Try Quick Repair first; if the issue continues, use Online Repair with an internet connection.
Will copying a chart sheet preserve its data links?
A copied chart may still refer to the original workbook. In the new workbook, check the chart's data source and update references if needed.




