Formula Errors

How to Fix Excel Formula Linking to Another Worksheet Not Working

Chanuka Geekiyanage Oct 12, 2026 870 views

Question details

The user needs to fix an issue where an Excel formula referencing another worksheet fails to display the calculated result.

How to Fix Excel Formula Linking to Another Worksheet Not Working

Product: Excel
Device & OS: not provided
Scenario: Working with formulas that reference cells in other worksheets, particularly when dealing with duplicated or merged cells.
Observed behavior: The destination cell stops displaying the linked value from the other worksheet and instead displays the raw formula text.

Before you start

Ensure that the worksheet names referenced in your formula exactly match the actual sheet tabs, especially if they contain spaces which require single quotes (e.g., ='Sheet 1'!A1).

Solution 1Recommended

Change Cell Format to General and Re-enter Formula

This is the most common fix when a destination cell displays the raw formula text instead of the calculated result.

When a cell is pre-formatted as 'Text', Excel treats any input—including formulas starting with an equals sign—as plain text. Changing the format back to 'General' allows Excel to recognize and evaluate the formula properly.

Select the affected cell

Click on the cell that is displaying the formula text (e.g., =Sheet1!A1) instead of the result.

Change cell formatting

Navigate to the 'Home' tab on the Excel ribbon, locate the Number format dropdown menu, and change it from 'Text' to 'General'.

Re-evaluate the formula

Double-click the cell to enter Edit mode, or click inside the formula bar at the top, and press Enter to refresh the calculation.

Change Cell Format to General and Re-enter Formula

Bulk Fix Tip: If you have an entire column of formulas displaying as text, select the column, go to 'Data' > 'Text to Columns', and click 'Finish' to instantly apply the General format to all cells.

Solution 2

Force Worksheet Recalculation

Use this method if the formula shows an outdated result instead of text, meaning Excel's automatic calculation might be paused.

Seamless Formula Linking

Easily Link Data Across Worksheets with WPS Spreadsheet

WPS Spreadsheet offers highly intuitive and accurate cross-sheet referencing, ensuring your formulas evaluate correctly without frustrating formatting glitches.

1. Open your workbook: Launch WPS Spreadsheet and open the file where you need to link data.
2. Start the formula: Type '=' in your destination cell to begin creating your formula.
3. Select the target worksheet: Click on the specific target worksheet tab at the bottom of the screen.
4. Complete the reference: Click on the cell you want to link to and press Enter to instantly generate the correct cross-sheet reference.

100% compatible with Microsoft Excel formulas and .xlsx filesAutomatic and real-time formula calculation across multiple sheetsIntuitive formula bar with clear syntax highlighting for fewer errors

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel formula just show the text I typed?

This typically happens because the destination cell is formatted as 'Text' before you enter the formula. Excel treats the equals sign and everything after it as regular characters. Changing the cell format to 'General' and pressing Enter inside the formula bar resolves this.

Do I need quotes around the sheet name when linking formulas?

Single quotes are only required if your worksheet name contains spaces or special characters (e.g., ='Sales Data'!A1). If the sheet name is a single continuous word (e.g., =Sheet1!A1), quotes are not necessary.

Why did my linked formula break after merging cells?

When you merge cells, only the data of the upper-left cell is retained, and the cell reference layout changes to encompass the merged area. This structural change can cause linking formulas to return #REF! errors or unexpected empty values. Unmerging and using 'Center Across Selection' is often a safer alternative.

Excel & Data Problems