Update Excel Sheet References After Renaming Worksheets
Question details
Update worksheet references in Excel formulas after a sheet is renamed, including references built with INDIRECT.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A workbook uses worksheet names in formulas, and the user wants references to remain correct when a sheet name changes.
- Observed behavior
- Regular worksheet references update automatically, but sheet names stored as text inside INDIRECT formulas do not.
Identify the renamed worksheet and check whether the affected formulas use INDIRECT or ordinary sheet references. If they use INDIRECT, note the exact new sheet name and where the old name appears.
Use regular worksheet references when possible
Use ordinary references when the formula does not need to select a sheet dynamically.
Select the formula cell and replace an INDIRECT expression with a direct reference. For example, use ='January'!O5 instead of =INDIRECT("'January'!O5").
Double-click the January sheet tab, enter the new name, and press Enter. Excel updates the direct reference to the new sheet name.
Select the formula cell and confirm in the formula bar that it points to the renamed sheet.

Build INDIRECT references from a sheet-name cell
Use a separate input cell when formulas need to select a worksheet dynamically.
Replace an old sheet name in existing formulas
Use Find and Replace when existing INDIRECT formulas contain a hard-coded sheet name.
Update worksheet references in WPS Spreadsheets
Open your workbook in WPS Spreadsheets and use direct references or a sheet-name input cell to manage references when worksheet names change.
- 1. Open the workbook: Open WPS Spreadsheets and choose File > Open to select your Excel workbook.
- 2. Enter the sheet name: In cell B1, enter the exact name of the worksheet you want to reference.
- 3. Build the formula: In another cell, enter =INDIRECT("'"&SUBSTITUTE($B$1,"'","''")&"'!O5") to retrieve O5 from the named worksheet.
- 4. Update and save: If you rename the worksheet using its sheet tab, update B1 to the new name. Check the formula result and choose File > Save.

Frequently Asked Questions
Why does INDIRECT return #REF! after I rename a sheet?
INDIRECT interprets the sheet name as text, so Excel does not update it automatically. Edit the formula or its input cell to match the new worksheet name.
Will a normal Excel sheet reference update when I rename the tab?
Yes. When you rename a worksheet by double-clicking its tab, Excel updates ordinary references such as ='January'!O5 to use the new name.
Can I change the sheet name used by several INDIRECT formulas at once?
Yes. Put the sheet name in a shared cell such as B1 and have the formulas refer to it. After renaming the sheet, update B1 to the exact new name.
How do I find hard-coded sheet names in formulas?
Choose Home > Find & Select > Find, open Options, and set Look in to Formulas. Search for the old sheet name and inspect the matches.




