---
title: "Discussion on \"IMPORTRANGE #REF! \"You need to connect these sheets\" in Google Sheets: click Allow access, then read the tooltip\" | Hashnode"
description: "Discussion on \"IMPORTRANGE #REF! \"You need to connect these sheets\" in Google Sheets: click Allow access, then read the tooltip\". You write =IMPORTRANGE(...) to pull a range from another spreadsheet and the cell shows #REF!. The URL is right, the range is right, and the tab exists. Hover the cell and the tooltip says You need to"
url: "https://hashnode.com/posts/importrange-ref-you-need-to-connect-these-sheets-in-google-sheets-click-allow-access-then-read-the-tooltip/6af27b689f97831e0a141277"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [IMPORTRANGE #REF! "You need to connect these sheets" in Google Sheets: click Allow access, then read the tooltip](https://sheeterror.hashnode.dev/importrange-ref-you-need-to-connect-these-sheets-in-google-sheets-click-allow-access-then-read-the-tooltip?utm_source=hashnode&utm_medium=feed)

You write =IMPORTRANGE(...) to pull a range from another spreadsheet and the cell shows #REF!. The URL is right, the range is right, and the tab exists. Hover the cell and the tooltip says You need to

Nov 10 · 3 min read · sheeterror.hashnode.dev  
Read the article

-   [#google-sheets](https://hashnode.com/tag/google-sheets)
-   [#spreadsheets](https://hashnode.com/tag/spreadsheets)
-   [#productivity](https://hashnode.com/tag/productivity)
-   [#tutorial](https://hashnode.com/tag/tutorial)

## Written by

[SheetError](https://hashnode.com/@sheeterror)

@sheeterror

  
[View profile](https://hashnode.com/@sheeterror)

Plain-English fixes for Google Sheets and Excel errors. Guides at sheeterror.com

Plain-English fixes for Google Sheets and Excel errors. Guides at sheeterror.com

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
