Formula Errors

How to Fix the Excel Formula Error for Worksheet References

Chanuka Geekiyanage Oct 10, 2026 870 views

Question details

The user is experiencing an error when trying to pull data using a formula that references a specific cell (E28) in another worksheet named "PAYE Calculator".

How to Fix the Excel Formula Error for Worksheet References

Product: Excel
Device & OS: not provided
Scenario: Referencing data from another worksheet or external workbook in spreadsheet formulas.
Observed behavior: The formula ='PAYE Calculator'!E28 returns an error (such as #REF! or #NAME?) due to an invalid sheet name, missing external workbook reference, or deleted target cell.

Before you start

Ensure that the workbook containing the source data is currently open and that you have not recently renamed, moved, or deleted any worksheet tabs.

Solution 1Recommended

Verify Worksheet Name and Existence within the Same Workbook

Ensure the sheet name in your formula perfectly matches the actual tab name at the bottom of your spreadsheet window.

A common cause for reference errors is a typo in the formula or a discrepancy in spaces within the worksheet tab name. If the formula does not match the tab name exactly, the spreadsheet software cannot locate the target cell.

Check the worksheet tab

Look at the bottom of your spreadsheet to confirm a tab named exactly 'PAYE Calculator' exists in your current workbook.

Fix extra spaces

Double-click the tab name to enter edit mode and ensure there are no hidden trailing or leading spaces that differ from your formula.

Update the formula

If the tab name differs, edit your formula to match the exact tab name, making sure it is enclosed in single quotes.

Verify Worksheet Name and Existence within the Same Workbook

Single Quotes Required: If your worksheet name contains spaces (like 'PAYE Calculator'), it must be enclosed in single quotes in the formula (e.g., ='PAYE Calculator'!E28).

Solution 2

Update the Formula for External Workbook References

If the 'PAYE Calculator' sheet is located in a completely different file, the formula must include the external file name.

Advanced Spreadsheet Editing

Manage Complex Formulas Easily with WPS Office

WPS Spreadsheet provides intuitive formula tools and excellent compatibility, making it simple to manage cross-sheet references, identify formula errors, and organize your financial data seamlessly.

1. Open your file: Launch WPS Spreadsheet and open the workbook you want to edit.
2. Start your formula: Type '=' in the cell where you want the referenced data to appear.
3. Select the source sheet: Click on the target worksheet tab (e.g., PAYE Calculator) at the bottom of the screen.
4. Select the cell: Click the specific cell (e.g., E28) and press Enter to let WPS automatically generate the correct cross-sheet formula syntax.

100% compatible with Microsoft Excel formulas and file formats (.xlsx, .xls, .csv).Intuitive formula auditing tools to quickly trace and fix reference errors.Lightweight and fast, even when handling large financial files with multiple worksheets.Free to use with a user-friendly interface similar to Microsoft Office.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my cross-sheet formula show a #REF! error?

The #REF! error appears when the cell, column, or worksheet you are referencing has been deleted or moved. Check if the 'PAYE Calculator' sheet or cell E28 was accidentally removed from your workbook.

How do I reference a sheet name that doesn't have spaces?

If the worksheet name has no spaces (e.g., PAYECalculator), you do not need single quotes around the sheet name. The formula can be written simply as =PAYECalculator!E28.

Can I pull data from a closed workbook without opening it?

Yes, but the formula must include the full file path. For example: ='C:\Documents\[WorkbookName.xlsx]PAYE Calculator'!E28. However, it is usually easier to keep both workbooks open while creating the initial link so the software formats the path automatically.

Excel & Data Problems