My question relates to source data. When you open the destination sheet - which includes an importrange cell, does the opening of the destination sheet cause the source sheet to fully refresh? I have a very large sheet that can take 10-15 seconds to fully refresh (it includes many sumifs cells as well as import from web site activities - which can take several seconds). If the very large sheet is my source sheet, will my destination sheet take the full amount of time for both sheets to refresh or will it only take the time to extract the as is data from the source sheet? This could also mean that in order to ensure that my destination data is up to date - that I open my source sheet first. Thanks for your response.
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?
Unfortunately, the Importrange only works with Sheets We would need to do a code that "converts" the excel file to sheets constantly, or, alternatively, that exports the information To be frank I'm not sure how is it done with Apps Script. I know there are add.ons such as SheetGo that may help you with that Kind Regards
May I ask? What if it displays #REF! importrange internal error? Is it because of slow internet or because the source sheet is too big and is constantly changing the number of sheets since it is used by the whole department?
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.
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.
Iam using two sheets from two separate workbooks of my account only and both I am the owner , still its not provide access to other sheet. Cannot understand why. If you can help me to solve this.
After seeing this, I realized you have to go under File > Save as google sheets to convert the spreadsheet to google sheets, then enter the new ID to your import range formula, that solved the same issue for me.
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
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.
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...
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?
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!
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?
Hi. May I ask for your help please. An error "Please use Desktop browser to connect to this sheet" occured to me. I tried any way possible, but still no luck. Thank you in advance :D
I had the same issue. But still cannot figure it out. I am the owner, but the refernce keep saying "You don't have permissions to access that spreadsheet". How can I solve this? I upload it as excel file into the google drive as spreadsheets. Please help me solve this matter
I solve it! I just have to save my excel file in that drive, click file > saved as Google Sheets. Wait for it as it pop up into another new window with new ID of spreadsheet. Then the access is now granted due to that new ID as saved google sheet! Thank God! I love my brain!
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.
Actually, the error came from the fact that I added the import range formula in a xls document even though data was imported from a google spreadsheet. Problem solved.
No worries. Actually it is good to leave these comments for future reference, and because it is weird that even though it is the same mistake (using an xls) the error messages sometimes vary. Thx for sharing the problem and the solution! Regards!
Hi bro My colleague has shared me his spreadsheet I created new spreadsheet from my account and applied importrange still it's saying don't have acces Pls tell me the solution
Hello! Make sure he shared with edit access And that when he shared, the advanced options are not deselected, that is that you have download and copy permits Regards!
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
I had issue with access too but I solved it! I just have to save my excel file in that drive, click file > saved as Google Sheets. Wait for it as it pop up into another new window with new ID of spreadsheet. Then the access is now granted due to that new ID as saved google sheet! Thank God! I love my brain!
Now I solve it! I solve it! I just have to save my excel file in that drive, click file > saved as Google Sheets. Wait for it as it pop up into another new window with new ID of spreadsheet. Then the access is now granted due to that new ID as saved google sheet! Thank God! I love my brain!
My question relates to source data.
When you open the destination sheet - which includes an importrange cell, does the opening of the destination sheet cause the source sheet to fully refresh?
I have a very large sheet that can take 10-15 seconds to fully refresh (it includes many sumifs cells as well as import from web site activities - which can take several seconds).
If the very large sheet is my source sheet, will my destination sheet take the full amount of time for both sheets to refresh or will it only take the time to extract the as is data from the source sheet?
This could also mean that in order to ensure that my destination data is up to date - that I open my source sheet first.
Thanks for your response.
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?
Unfortunately, the Importrange only works with Sheets
We would need to do a code that "converts" the excel file to sheets constantly, or, alternatively, that exports the information
To be frank I'm not sure how is it done with Apps Script. I know there are add.ons such as SheetGo that may help you with that
Kind Regards
You didn't cover the "what if you don't get the option to allow access"
That's the issue I'm having!
In this case, you should check if you have been shared the original file, or if it's an excel file
Kind Regards
This video was a great help. Small tip in the end about the length of the sheet code was my problem... thanks a ton.
Glad it was useful!
Regards!
May I ask? What if it displays #REF! importrange internal error? Is it because of slow internet or because the source sheet is too big and is constantly changing the number of sheets since it is used by the whole department?
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.
How many "connections" do you have. It tends to become instable with more than 50 connections
Kind Regards
thank God for your video!! finally figured out why i cant get access to the sheet i basically own lol! keep it up!
Thank you for your kind words!
And I'm glad you solved it
Regards!
Thank you for saving my stress! All I forgot was the " " between the links so I am glad you pointed it out
Excellent!
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.
Could you show me the formula?
Kind Regards
@@practicalsheets Thanks for the reply. I figured it out. I had to refresh the page because I had it open for days and it wasn't updating.
So, is there a solution to uploaded sheets to work with the importrange now?
Unfortunately not. You should convert it to Sheets first
Regards!
Iam using two sheets from two separate workbooks of my account only and both I am the owner , still its not provide access to other sheet. Cannot understand why. If you can help me to solve this.
Can you check if one of the files is an excel file?
Kind Regards
Good evening, I have issue that "You don't have permissions to access that spreadsheet." but the excel was create by me.
Me too!
same
After seeing this, I realized you have to go under File > Save as google sheets to convert the spreadsheet to google sheets, then enter the new ID to your import range formula, that solved the same issue for me.
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
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.
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...
Hello!
This cannot be done with functions.
We should use Google Apps Script
Regards!
Thanks a lot, this video was usefull
Thanks for commenting!
I'm having a problem that every hour I have to allow access and not only one time, do you know anything about?
Hmmm
Haven´t heard about it
Maybe they are chaging the permissions for the source file?
Regards!
Thanks, Last one resolve my issue.
Excellent!
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?
Hello! Is your formula pretty complex? Or just IR?
Regards!
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!
THANKS! THIS LIT SAVED MY LIFE
I have an issue of internal import range error which always shows whenever i link 2-3 sheets
Hello
Have you been able to fix it?
I´ll prepare a new video
Regards!
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?
How much rows do you have? How many columns?
Regards!
Hi. May I ask for your help please. An error "Please use Desktop browser to connect to this sheet" occured to me. I tried any way possible, but still no luck. Thank you in advance :D
Hi!
Wow, I´ve never seen that mistake
Are you in a tablet or phone?
That may be it
Regards!
same with my problem
@@practicalsheets
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?
Hello!
Are you sure it is a Sheet and not an Excel?
Regards!
It is an excel not a spreadsheet, Sir. I had the same problem.
I had the same issue. But still cannot figure it out. I am the owner, but the refernce keep saying "You don't have permissions to access that spreadsheet". How can I solve this? I upload it as excel file into the google drive as spreadsheets. Please help me solve this matter
I solve it! I just have to save my excel file in that drive, click file > saved as Google Sheets. Wait for it as it pop up into another new window with new ID of spreadsheet. Then the access is now granted due to that new ID as saved google sheet! Thank God! I love my brain!
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.
Actually, the error came from the fact that I added the import range formula in a xls document even though data was imported from a google spreadsheet.
Problem solved.
No worries. Actually it is good to leave these comments for future reference, and because it is weird that even though it is the same mistake (using an xls) the error messages sometimes vary.
Thx for sharing the problem and the solution!
Regards!
Thank you! This helped me a lot. :)
Hi bro
My colleague has shared me his spreadsheet
I created new spreadsheet from my account and applied importrange still it's saying don't have acces
Pls tell me the solution
Hello!
Make sure he shared with edit access
And that when he shared, the advanced options are not deselected, that is that you have download and copy permits
Regards!
@@practicalsheets bro still it's not working
@@sprime752 Are you sure it´s a Google Sheet? Not an excel? Regards!
Thanks a lot, why when I do Allow access, it
is keep loading (saying adding permission)? thanks again
Is the file yours?
Regards!
shared the file as well but still showing you don't have permission to access the spreadsheet.
Is it an Excel file?
Same here
@@practicalsheets
It's a live sheet. This formula is only workable in sheet which has less argument. Not workable for heavy file.
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
My file could not allow access, it buffers with stating adding permission
I had issue with access too but I solved it! I just have to save my excel file in that drive, click file > saved as Google Sheets. Wait for it as it pop up into another new window with new ID of spreadsheet. Then the access is now granted due to that new ID as saved google sheet! Thank God! I love my brain!
Thank you
Thank you for commenting!
Is ower can edit or not?
Now I solve it! I solve it! I just have to save my excel file in that drive, click file > saved as Google Sheets. Wait for it as it pop up into another new window with new ID of spreadsheet. Then the access is now granted due to that new ID as saved google sheet! Thank God! I love my brain!
None of this working. Keep error
What error is it showing?
error parsing the formula
I’m having the same issue