Google Sheets IMPORT functions · error message

Google Sheets: Import Range internal error

RetryablePermissions and access

Last verified

The exact message
#REF! Import Range internal error.

What it means

This is IMPORTRANGE's generic failure: something went wrong reading the source file and Sheets does not say what. There is no single documented cause; the message has been reported for permission problems, oversized ranges, long chains of imports, and transient service issues.

Because the message is generic, the useful approach is elimination. A formula that resolves on its own after a reload points to a transient or load-related problem. One that fails every time points to something about this specific source, range or account.

A Google Docs Editors Community thread on this exact message was marked as a duplicate of a recurring issue without a published fix, so treat persistent cases as something to work around rather than wait out.

What it looks like

=IMPORTRANGE("1AbC...xyz", "Raw!A:AZ")

#REF!
Import Range internal error.

Why it happens

  • The source spreadsheet is very large or slow to calculate, and IMPORTRANGE waits for calculations in the source to finish.
  • The import is part of a chain (file C imports from B, which imports from A), compounding delays.
  • Many receiving files read the same source at once.
  • Access to the source was partially revoked or the source moved between drives.
  • A temporary problem on Google's side.

How to fix it

  1. Reload the destination file. If the error clears, it was transient.
  2. Reduce the range to a bounded block and see if the error disappears; if so, size or load is the cause.
  3. Open the source file and check it calculates quickly; remove heavy volatile formulas there.
  4. Point the destination directly at the original source rather than an intermediate file that also uses IMPORTRANGE.
  5. Delete the formula and re-enter it, then click Allow access if prompted.
  6. Check the Google Workspace Status Dashboard for Sheets incidents.

How to stop it recurring

Avoid IMPORTRANGE cycles and long chains, which Google's help page warns against, and limit how many receiving files read the same source. Keep the source lightweight: a dedicated export tab with plain values is far more reliable than a heavily calculated sheet.

Official documentation: support.google.com/docs/answer/3093340. See all Google Sheets error messages or the Google Sheets limits and quotas.

Related errors

Definitions

Quick answers

What does "Import Range internal error" mean in Google Sheets?

This is IMPORTRANGE's generic failure: something went wrong reading the source file and Sheets does not say what. There is no single documented cause; the message has been reported for permission problems, oversized ranges, long chains of imports, and transient service issues. Because the message is generic, the useful approach is elimination.

How do I fix "Import Range internal error"?

1. Reload the destination file. If the error clears, it was transient. 2. Reduce the range to a bounded block and see if the error disappears; if so, size or load is the cause. 3. Open the source file and check it calculates quickly; remove heavy volatile formulas there. 4. Point the destination directly at the original source rather than an intermediate file that also uses IMPORTRANGE. 5. Delete the formula and re-enter it, then click Allow access if prompted. 6. Check the Google Workspace Status Dashboard for Sheets incidents.

When an IMPORT formula cannot read the page

IMPORTXML and IMPORTHTML only see the HTML the server sends. An Autonoly extraction step reads the page in a real browser and writes rows to Google Sheets. Sites that block automated visitors can still block it.

Also see Google Sheets integration.