Google Sheets Linking Between Sheets Not Working? Here’s How To Fix IT

If links between sheets in Google Sheets aren’t working, formulas return #REF!, #N/A, or blank, or data doesn’t update across sheets.
This usually shows up when referencing another tab or file using direct references or IMPORTRANGE.

This guide fixes it step by step.

Why the Issue Happens

• Incorrect sheet name or reference syntax
• Missing permissions for external sheets (IMPORTRANGE)
• Renamed or deleted source sheet/tab
• Text vs number mismatch across sheets
• Extra spaces or hidden characters
• Using wrong range or column references
• Broken links after copy/paste or file duplication
• External data not refreshing

Step-by-Step Fixes

Step 1: Use Correct Sheet Reference Syntax

For linking within the same file:

=Sheet2!A2

If sheet name has spaces:

='Sales Data'!A2

Incorrect naming is a common cause of #REF!.

Step 2: Fix #REF! Errors

#REF! usually means:

• Sheet name is wrong
• Referenced cell/range doesn’t exist

Fix:

• Recheck sheet name
• Re-enter formula manually

Step 3: Fix IMPORTRANGE Access Issues

If linking between files:

=IMPORTRANGE("FILE_ID", "Sheet1!A:B")

Fix:

1. Enter formula
2. Click the cell
3. Click “Allow access”

Without this, it won’t work.

Step 4: Verify Spreadsheet ID or URL

Incorrect ID = no data.

Correct format:

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/FILE_ID/edit", "Sheet1!A:B")

Or just:

=IMPORTRANGE("FILE_ID", "Sheet1!A:B")

Step 5: Fix Range Syntax

Correct:

"SheetName!A1:C100"

If sheet name has spaces:

"'Sheet Name'!A:B"

Wrong syntax breaks the link.

Step 6: Fix Data Type Mismatch

Example:

• Sheet1 → 100 (number)
• Sheet2 → "100" (text)

Link may fail in lookups.

Fix:

=VALUE(A2)

Standardize formats across sheets.

Step 7: Remove Extra Spaces

Hidden spaces cause mismatch.

Fix:

=TRIM(A2)

For full column:

=ARRAYFORMULA(TRIM(A2:A100))

Step 8: Check for Renamed Sheets

If source tab is renamed, links break.

Example:

=OldName!A2

Fix:

• Update to new name

Step 9: Force Refresh for External Links

IMPORTRANGE may not update instantly.

Fix:

=IMPORTRANGE("FILE_ID", "Sheet1!A:B") + NOW()*0

This triggers recalculation.

Step 10: Test with Simple Reference

Before complex formulas, test:

=Sheet2!A1

or

=IMPORTRANGE("FILE_ID", "Sheet1!A1")

If this fails, issue is with connection—not formula logic.

Common Mistakes

• Misspelling sheet names
• Forgetting quotes for sheet names with spaces
• Not allowing access for IMPORTRANGE
• Using incorrect spreadsheet ID
• Ignoring data type mismatches
• Not updating references after renaming sheets
• Expecting instant refresh for external data

Pro Tips / Better Alternatives

Use Named Ranges for Stability

Instead of:

=Sheet2!A2:A100

Use named range like:

=SalesData

More stable and easier to manage.

Use QUERY with IMPORTRANGE

=QUERY(IMPORTRANGE("FILE_ID", "Sheet1!A:C"), "SELECT Col1, Col2", 1)

Reduces data load and improves performance.

Use Helper Sheet for Imports

Best practice:

• Import once in a separate tab
• Reference locally

Improves speed and reduces errors.

Validate Data Before Linking

Ensure:

• Clean data
• No spaces
• Correct formats

Avoid linking dirty datasets.

Avoid Too Many External Links

Multiple IMPORTRANGE calls:

• Slow down sheet
• Increase failure risk

Consolidate where possible.

Bottom Line

If linking between sheets isn’t working, fix in this order:

1. Verify correct sheet name and syntax
2. Fix #REF! errors (range or sheet issue)
3. Allow access for IMPORTRANGE
4. Check spreadsheet ID and range
5. Clean data (spaces, formats)
6. Refresh external connections

Most issues come from syntax errors, permissions, or dirty data.
Fix those, and your sheet links will work reliably.