Excel sheet tabs

Question

Some of my Excel sheet tabs lose the names I've given them and revert to sheet numbers. My file has 14 sheets. It's always the same 3 sheets that lose their names.

Answer 1

It sounds like you are experiencing an issue where certain sheet names in your Excel workbook are reverting to default names (like Sheet1, Sheet2, etc.). This can happen for a few reasons:

1. Excel Limitations: Excel has limitations on the number of characters and the types of characters that can be used in sheet names. If the names exceed these limits or contain invalid characters, Excel may revert to default names.
2. Corruption in the Workbook: Sometimes, the workbook may become corrupted, leading to unexpected behavior such as losing sheet names. You might want to try saving the workbook in a different format (like .xlsx) or creating a new workbook and copying the sheets over.
3. Macros or Add-ins: If you are using any macros or third-party add-ins, they might interfere with the sheet names. Check if any macros are running that could be renaming the sheets.
4. Hidden Sheets: If sheets are hidden or if there are issues with visibility settings, it might affect how names are displayed. You can check for hidden sheets by going to the View tab and selecting Unhide.

If the problem persists, consider checking for updates to Excel or repairing the Office installation to resolve any underlying issues.

Answer 2

Hello Fred and Ray Weinand,

Thank you for reaching out in Microsoft Q&A forum.

I understand how frustrating it is when specific Excel sheets keep losing their custom names and revert back to default sheet numbers.

What you describe usually happens when Excel cannot save the workbook state correctly, or when those three sheets contain elements that trigger an internal refresh. Since only the same sheets are affected, it often points to something inside those worksheets rather than the whole file.

You can try the following:

1. Save the file in a new location with a new name
2. Check whether those 3 sheets were copied from another workbook
   • Sheets copied from older or corrupted files sometimes carry hidden metadata that resets the tab name.
3. Inspect for macros, Power Query, or external links
   • A macro, query refresh, or link could be rewriting sheet names automatically.
   • Open View > Macros and confirm none reference sheet renaming.
4. Turn off AutoSave temporarily and rename the sheets
   • Then save manually. If AutoSave is interfering with an unsynced version, this helps isolate it.
5. Move the 3 problematic sheets into a new workbook
   • Save, close, reopen, then rename them.
   • If the names stay, move them back into the main workbook.
6. Perform an Office repair
   • Sometimes Excel’s behavior persists due to app-side corruption.
   • A Quick Repair is enough in most cases.

If nothing changes after these steps, the workbook itself is likely partially corrupted, and the stable fix is to recreate those three sheets in a fresh workbook.

Hope this helps

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".  

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread