Google Sheets - IMPORTRANGE Data Access Control from Other Spreadsheets

How to use IMPORTRANGE function in Google Sheets & still have data access control over other spreadsheets?

#google #workspace #sheets

[gonthiniganganiranjankumar]

Thanks for sharing the great tip and we are waiting for Big Query video

[OncologyEvents]

Excellent ! and direct to the point, I really liked the show.

[satishsatpute]

VERY SIMPLE WAY TO EXPLAIN THANK YOU VERY MUCH!!!😊

[OncologyEvents]

i liked the mediator sheet ... its like protective shield to the main brain sheet

[jeffbetancourt]

Is there a way to import the range along with the formating of the data?

[MISComputerNET]

Excellent tip and great explanation, as always.

[xyzapitbull]

Thanks for the tip, or you could use the protect cell/range/sheet? To restrict others from editing the formula.

[M]

Hi, I have a question! Using importrange, i pull data from file A to file B. And if i edit A, B will automatically updated. How do i make it so if I edit B, A also updated? Is this possible? Please help!!

[glenn]

I am entering payment amounts in one sheet and using these amounts to make calculations in another sheet after using IMPORTRANGE. At the bottom of each set I am calculating a total. From time to time, a new row will be added in a set on the first sheet. How do I get the rows to adjust in the second sheet?

[abdullahquhtani]

I tried this with a sheet that has more that 100, 000 rows and it fails.

[davidfernandezbajo]

Thank you. Is therr a way to revoke the access from a spreadsheet?

[HarmitJoshi]

Google Sheet
How to create a file where we have more than one data entry persons and wants to show separate sheet for each of them ?
can we do that without creating new sheet for each person and final merge data with one sheet ?
Big fan of your work doing good work

[indahasrinfulaedzah]

Hello, please help me!
Would you like to make the tutorial using excel online from one drive too? Because I've tried, but can't work

[ProGamer-upcn]

How to automatically update the data in importrange sheet when we add new data into main sheet?

[Perfectbuy]

I don't Want to enter import range formula again and again for every new sheet... Any easy way?

[Saffan_Identity]

It says that You don't have permission to access that where I'm the owner of both the sheets and those are shared with another person too. Please help me

[AhmedGamal-kweq]

You don't have permissions to access that spreadsheet.

[francisalvar]

I correctly put the formula but errors appear when I click the error no allow access appear...

[rassamrasheed]

After you import the data, then add a comment on column C for each row imported. the column C data and ColumnA, ColumnB does not sync when new data is entered to the A, B. how can you sync or link the rows. can you do a tutorial on this please.

[redhawklw]

If someone updates the numbers in the 'source data' sheet and you don't have your intermediate sheet open on your browser, will you still have updated numbers on your final sheet? Assuming you only have the final sheet open.