How to Fix Excel #NAME? Errors for Sheet Names with Spaces
Question details
The user needs to resolve a #NAME? error that occurs in cross-sheet formulas when referencing worksheet names containing 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.
Verify the exact spelling of your target worksheet tab, ensuring there are no trailing spaces or unsupported special characters before editing your formula.
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.
Select the cell displaying the #NAME? error and click into the Formula Bar at the top of your screen.
Delete any unwanted characters, such as an extra '@' symbol, that may have been typed before the worksheet name.
Wrap the exact worksheet name in single quotes. For example, change AOV Calculation to 'AOV Calculation'.
Ensure an exclamation mark (!) separates the quoted sheet name and the cell reference, resulting in exactly: ='AOV Calculation'!D6. Press Enter to apply.

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. Open your workbook in WPS: Launch WPS Office and open your spreadsheet file containing multiple worksheets.
- 2. Start your formula: Type an equals sign (=) in the cell where you want the linked data to appear.
- 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. Press Enter to confirm: Hit Enter on your keyboard. WPS Office perfectly executes the cross-sheet formula without #NAME? errors.

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.




