Fix the IMPORTRANGE error

Excel & Google Sheets

What IMPORTRANGE means

IMPORTRANGE pulls data from one Google Sheets file into another. When it stops working or returns an error, the cause is almost always one of three things: the source URL or range is wrong, access has not been authorized, or the source sheet name has changed. Identifying which one is failing tells you exactly what to fix.

Common causes

The spreadsheet URL was changed (e.g., the file was moved or renamed) so the embedded URL no longer resolves to the source.
The sheet tab name in the range string has changed, been deleted, or contains special characters not wrapped in single quotes.
The range string uses an invalid notation (e.g., missing the sheet name entirely, or using a row-only reference A:A without specifying a sheet).
Authorization was not granted or was revoked — the formula returns #REF! with an access message.
The source spreadsheet is too large and the IMPORTRANGE times out before all data is fetched, showing an error intermittently.

Example fix

Broken

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/ABC123","Data!A:Z")

Fixed

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/ABC123","'Data Export'!A1:Z500")

Added single quotes around the sheet name (which contains a space), changed the range from open-ended columns to a bounded range to reduce load, and re-authorized access.

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

How to fix it

1Open the source spreadsheet and copy its URL from the browser address bar. Paste it fresh into the IMPORTRANGE formula to rule out a stale URL.
2Confirm the sheet name exactly: the range string must be "SheetName!A1:Z100". If the sheet name contains spaces or special characters, wrap it in single quotes: "'My Sheet'!A1:Z100".
3Re-authorize access: click the cell, read the tooltip, and click Allow access if it appears.
4Test with a minimal range first: =IMPORTRANGE("URL","Sheet1!A1") — if a single cell imports, expand the range incrementally.
5If the source sheet is very large, import only the rows and columns you need rather than entire columns to avoid timeout errors.

Stop hunting errors by hand.

Upload your spreadsheet and the Auditor flags every IMPORTRANGE and broken formula at once — or paste this one formula and get the fix explained.

Frequently asked

Why does IMPORTRANGE work sometimes and show an error other times?

Intermittent errors usually mean the source file is large and the request is timing out. Narrow the imported range to only the rows and columns you need, or break it into multiple smaller IMPORTRANGE calls.

Can I use IMPORTRANGE inside a QUERY formula?

Yes. =QUERY(IMPORTRANGE("URL","Sheet1!A:D"),"SELECT Col1, Col3 WHERE Col2 > 10") is a common and effective pattern. Authorize the IMPORTRANGE first on its own before nesting it.

Does editing the source spreadsheet automatically update the imported data?

Yes. IMPORTRANGE refreshes automatically, though there can be a short delay (usually under a minute). You do not need to manually refresh the destination sheet.

Related formulas

IMPORTRANGE QUERY (Google Sheets)FILTER IFERROR

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026