Formula Errors

Update Excel Sheet References After Renaming Worksheets

Elise WilliamsElise Williams Nov 18, 2026 869 views

Question details

Update worksheet references in Excel formulas after a sheet is renamed, including references built with INDIRECT.

Update Excel Sheet References After Renaming Worksheets
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.
Before you start

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.

Solution 1Recommended

Use regular worksheet references when possible

Use ordinary references when the formula does not need to select a sheet dynamically.

1
Edit the formula

Select the formula cell and replace an INDIRECT expression with a direct reference. For example, use ='January'!O5 instead of =INDIRECT("'January'!O5").

2
Rename the worksheet

Double-click the January sheet tab, enter the new name, and press Enter. Excel updates the direct reference to the new sheet name.

3
Check the result

Select the formula cell and confirm in the formula bar that it points to the renamed sheet.

Use regular worksheet references when possible
Work with worksheet references in WPS

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. 1. Open the workbook: Open WPS Spreadsheets and choose File > Open to select your Excel workbook.
  2. 2. Enter the sheet name: In cell B1, enter the exact name of the worksheet you want to reference.
  3. 3. Build the formula: In another cell, enter =INDIRECT("'"&SUBSTITUTE($B$1,"'","''")&"'!O5") to retrieve O5 from the named worksheet.
  4. 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.
Manage dynamic sheet references with INDIRECT and a separate input cellOpen and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet formulas and worksheet tabsUse WPS Office for free
microsoft office alternative - wps office

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.