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
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
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.
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.
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.
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...
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!
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 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?
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?
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
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. 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 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!
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!
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!
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!
Thank you for saving my stress! All I forgot was the " " between the links so I am glad you pointed it out
Excellent!
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!
Good evening, I have issue that "You don't have permissions to access that spreadsheet." but the excel was create by me.
Me too!
Thanks a lot, this video was usefull
Thanks for commenting!
Thanks, Last one resolve my issue.
Excellent!
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
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
THANKS! THIS LIT SAVED MY LIFE
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
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.
Thank you! This helped me a lot. :)
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.
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!
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!
So, is there a solution to uploaded sheets to work with the importrange now?
Unfortunately not. You should convert it to Sheets first
Regards!
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!
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!
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 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?
How much rows do you have? How many columns?
Regards!
Thank you
Thank you for commenting!
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!
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
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. 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 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!
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!
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!
None of this working. Keep error
What error is it showing?
error parsing the formula
I’m having the same issue