IMPORTRANGE tips and errors - Google SHEETS

In this tip, we will learn about IMPORTRANGE, with tips, tricks and the most common errors of this great Google Sheets function.

➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions

➤You can also subscribe to the channel where you´ll find a new Sheets video every week.

Here are some of the places where you can follow and support me:

Any suggestion, question or insights, feel free to comment below

[mrm]

You didn't cover the "what if you don't get the option to allow access"

[murtazafit]

This video was a great help. Small tip in the end about the length of the sheet code was my problem... thanks a ton.

[ldzgrfj]

Good evening, I have issue that "You don't have permissions to access that spreadsheet." but the excel was create by me.

[isellemarieluna]

thank God for your video!! finally figured out why i cant get access to the sheet i basically own lol! keep it up!

[IsaEddie]

Thank you for saving my stress! All I forgot was the " " between the links so I am glad you pointed it out

[channelst]

Hello! Great video! Do you have any sugestion for the case where the original file was an exel file? For the past year I that file only using sheets. Now I want to use the importrange in another G sheet, but the original is an exel. What do you recommend?

[dragomirbunul]

Hi, I have a question about this topic. The same formula referencing the same sheet works in some sheets, but in other sheets, it doesn't. All of the sheets are mine, some are shared with other accounts and others are only mine, but again, no rule, in some works and in some doesn't.

[japhetholisa]

So, is there a solution to uploaded sheets to work with the importrange now?

[AndreBascoBecker]

I'm having a problem that every hour I have to allow access and not only one time, do you know anything about?

[flex]

I did every single thing on the video i have a data base for my appointment setters but i only want them to have to view only there tabs i used this formula worked for some but didint work for others even tho i didi everything right error cant find range or sheet for the imported range Help ty

[skinperfectglendora]

Help? I am using importrange so the sum of one cell from one of my Google Sheets shows up exactly the same on another Google Sheet. But the actual totals are different. It's the same cell being referenced, but one cell shows "10" as my original number on one sheet, but the other cell shows "12" on the other sheet, even though the cell reference is exactly the same. Why is Google Sheets adding 2 numbers to my original number? Thank you.

[TindSarkar]

I have an issue of internal import range error which always shows whenever i link 2-3 sheets

[JuniartoGautamaSimanjunt-qint]

I really thank you for your explanation. But, my cells have fill color and it could not be imported, only the alphabets and numbers were imported. How can I import the fill color of the cells and the merged cells?
Thanks in advance...

[diazo]

Worked for a week trying to find out why I could not get access to another sheets document. Then learned that I could not access a conversion from excel to sheets. Thanks. Problem solved

[yhnjcfd]

I need your help if possible please? The data that is being returned is either in the incorrect order or has spaces of several cells between each result. My brian huts trying to figure out what I'm doing wrong.

[Slabysz]

I created a tab with a limited section of rows and columns, but when I share that tab (to another one of my email accounts), it shows all the columns and rows of the original tab where the importrange was sourced. Why? Thanks!

[solarbi]

Good afternoon. I have the same issue. I'm doing the importrange with array and sometimes there's a trouble: "internal error on import range". In my worksheets are several import ranges, but in all of them i've limited up to 5.000 rows per array, and the problem persists. do you have a clue what can it be?

[well]

Hi! It says "You don't have permissions to access that spreadsheet.", but I am using one same account for both sheets. How can I fix this?

[salmazafira]

hallo i have some issue with this importrange formula, the formula was true but it still getting loading after 24 hours more. how to fix it? is it because of there's a lot of data in my googlesheet?

[ChrisHote]

hello, I am facing an issue whereas after clicking "Allow access", I am getting an "adding permissions ..." message that runs forever. The google-spreadsheet I am importing from is mine and it includes 10 tabs. The tab I need to import from is a A1:P100 matrix and I need to import A1:B2. Is that typical the "adding permissions ..." process takes so long. 30' so far.