Chart & Visualization Issues

Fix Excel Chart Sheet Names Resetting After Reopening

Kushani NimanthikaKushani Nimanthika Nov 22, 2026 869 views

Question details

Keep custom Excel chart sheet names after closing and reopening a workbook.

Fix Excel Chart Sheet Names Resetting After Reopening
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.
Before you start

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.

Solution 1Recommended

Repair the Microsoft Office installation in Windows

Use Office repair if chart sheet names reset in multiple workbooks or you suspect an installation problem.

1
Close Office apps

Save your open workbooks and close Excel and other Microsoft Office applications.

2
Open installed apps

In Windows, open Settings and select Apps, then Installed apps or Apps & features.

3
Start Office repair

Find Microsoft 365 or Microsoft Office in the app list, select Modify, and choose Quick Repair. Confirm the repair when prompted.

4
Try Online Repair if needed

If Quick Repair does not help, return to Modify, choose Online Repair, and follow the prompts. An internet connection is required.

5
Retest the workbook

Open the workbook in Excel, rename a chart sheet, save the file, and reopen it to check whether the name remains.

Repair the Microsoft Office installation in Windows
Windows repair options: These repair steps apply to Office installations on Windows. Menu names can vary by Windows and Office version.
Free Microsoft Office alternative

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.

Open and edit spreadsheets with chart toolsCompatible with Microsoft Excel formats such as XLSX and XLSFamiliar interface makes it easier to move from ExcelFree and lightweight office suite
microsoft office alternative - wps office

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.