Formula Errors

How to Fix Excel #NAME? Errors for Sheet Names with Spaces

Anum MushtaqAnum Mushtaq Nov 10, 2026 871 views

Question details

The user needs to resolve a #NAME? error that occurs in cross-sheet formulas when referencing worksheet names containing spaces.

How to Fix Excel #NAME? Errors for Sheet Names with Spaces
Product
Excel
Device & OS
not provided
Scenario
Pulling data from another worksheet where the target sheet tab name includes spaces or special characters.
Observed behavior
Excel returns a #NAME? error because the formula parser misinterprets the unquoted sheet name and fails to locate the referenced data.
Before you start

Verify the exact spelling of your target worksheet tab, ensuring there are no trailing spaces or unsupported special characters before editing your formula.

Solution 1Recommended

Enclose the Worksheet Name in Single Quotation Marks

Correct the syntax error by adding single quotation marks around the sheet name, which is mandatory for names containing spaces.

When referencing cells across different worksheets, spreadsheet programs require that any sheet name containing spaces or special characters be enclosed in single quotes. Failing to do so breaks the formula parser, resulting in a #NAME? error or syntax warning.

1
Locate the broken formula

Select the cell displaying the #NAME? error and click into the Formula Bar at the top of your screen.

2
Remove unnecessary symbols

Delete any unwanted characters, such as an extra '@' symbol, that may have been typed before the worksheet name.

3
Add single quotation marks

Wrap the exact worksheet name in single quotes. For example, change AOV Calculation to 'AOV Calculation'.

4
Complete the cross-sheet reference

Ensure an exclamation mark (!) separates the quoted sheet name and the cell reference, resulting in exactly: ='AOV Calculation'!D6. Press Enter to apply.

Enclose the Worksheet Name in Single Quotation Marks
Formula Updated: The #NAME? error should instantly disappear and the cell will accurately display the value pulled from the referenced worksheet.
WPS Spreadsheet

Easily Reference Data Across Worksheets with WPS Office

WPS Spreadsheet handles cross-sheet referencing intuitively and is fully compatible with Excel formulas. You can seamlessly link data across multiple sheets without worrying about syntax errors manually, as WPS can automatically format your formulas when clicking.

  1. 1. Open your workbook in WPS: Launch WPS Office and open your spreadsheet file containing multiple worksheets.
  2. 2. Start your formula: Type an equals sign (=) in the cell where you want the linked data to appear.
  3. 3. Select the target cell visually: Click on the tab of the target worksheet (e.g., AOV Calculation), then click the desired cell (e.g., D6). WPS Spreadsheet automatically formats the formula as ='AOV Calculation'!D6.
  4. 4. Press Enter to confirm: Hit Enter on your keyboard. WPS Office perfectly executes the cross-sheet formula without #NAME? errors.
Fully compatible with Microsoft Excel formulas and cross-sheet references (.xlsx)Intuitively adds required quotation marks automatically when using mouse selectionFree, lightweight, and fast alternative to heavy spreadsheet programs
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel show a #NAME? error even without spaces in the sheet name?

A #NAME? error typically occurs when a function name is misspelled, a defined named range is missing, or text strings within the formula lack double quotation marks. Double-check your function spelling and named ranges.

Do I need quotation marks for sheet names without spaces?

No, single quotation marks are strictly required only if the worksheet name contains spaces or specific special characters. However, adding them to single-word sheet names will not cause any errors and is a safe habit.

What other special characters trigger a formula error in worksheet references?

Characters such as hyphens (-), ampersands (&), and parentheses in a worksheet name will also require the name to be enclosed in single quotation marks within your formula to avoid parsing errors.