How to share Google Sheet Tabs to different people
HTML-код
- Опубликовано: 6 сен 2024
- In this video tutorial, we are going to learn how to share the google sheet sheets to different people.
Here is the google sheet, let's name it “To Share” sheet.
Let's change the sheet name as tab1. Now let's insert some data over here.
For best understanding let's change the label as student1.
Now let's duplicate the sheet and label it as student2. Let’s make it different from the previous sheet.
If we share the student1 sheet to someone, can student1 get access to student2 sheet?
Let’s check.
I’m sharing to master2teach@gmail.com as student1. Giving only view access for now.
Share it.
Checking mail. Here it is. Opening it. Here is the sheet. As you can see, student2 sheet is also available and accessible.
Actually there are no such facilities provided by Google. So we have to make some twice on it.
Let’s see what we can do to achieve our requirements.
First copy the sheet code from the URL. After D.
Create a new sheet. Let's name it as student1. Sheet name as well.
To import data from another sheet, we have an import range formula.
Paste the sheet id. Sheet name. Exclamation sign. Import from A1 to E15
Need to allow access.
Create another new sheet. Name it as student2.
Implement the same formula over here as well.
Import range
Now we have two new sheets with different names whereas we have one main sheet name as “ to share”.
Navigate to student1 sheet and share to student1.
Again using the same mail. View only access. Send.
Check mail and Open
Now if we change to main sheet data, it will reflect the shared sheet and student2 data is not accessible to student1 and vice versa.
In this way we can manage all the data from the main sheet and can share different sheets to different people with limited access.
I hope you learn from this tutorial. Please don’t forget to like, share, and subscribe to the channel.
Thank you
SUBSCRIBE to our RUclips channel for more videos: www.youtube.co...
Like us on Facebook: / master2teach
For more content go to master2teach.com/
Great
Thank you, it was very helpful.
But it is taking time to update, more thank 10 min. Can please suggest why this is take time to update.
Great video and clearly explained, tried it and it works perfectly. Thank you
Wow very smart. thank you very much
Thanks great video
Why did you not just go to File/Share then select which Tab to share and email copied link????
in addition to this the system requires significant data communication and other datacomplexity adjustment factor are treatedas average. compute the unadjusted function point and function point of the project .the software is going to the implemented in c++ language so also calculate the size of the project
Please reply anybody
hi, can we do the same thing but not just the sheet tab, but the whole worksheet? meaning i have one master worksheet where i can view 2 different student's independent work sheet on my master worksheet?. thank you for your advice
Ofcourse it's possible. Try searching "ImportRange"
❤
Allow access button cannot be found
i tried but it said sheet not foung :(
That's not sharing. That's copying.
❤