1
00:00:00,080 --> 00:00:04,897
You want to share only the Status tab, while the Budget tab stays private.

2
00:00:04,897 --> 00:00:07,993
In Google Sheets, sharing applies to the spreadsheet file.

3
00:00:07,993 --> 00:00:11,778
Hiding or protecting Budget is not a safe way to give

4
00:00:11,778 --> 00:00:13,498
someone access to just Status.

5
00:00:13,498 --> 00:00:16,251
Make a separate file for the shareable tab.

6
00:00:16,851 --> 00:00:21,362
The practice workbook has two tabs: Status with harmless project tasks

7
00:00:21,362 --> 00:00:24,233
and Budget with clearly fictional private amounts.

8
00:00:24,233 --> 00:00:26,283
Open a copy in Sheets.

9
00:00:26,283 --> 00:00:30,385
Before changing permissions, identify the Status tab as the only

10
00:00:30,385 --> 00:00:32,435
material the recipient should see.

11
00:00:33,035 --> 00:00:37,750
Open the Status sheet tab menu and choose Copy to, then New spreadsheet.

12
00:00:37,750 --> 00:00:40,289
Name the result Workshop Status Share Copy.

13
00:00:40,289 --> 00:00:44,278
Do not select Hide sheet or Protect sheet as a substitute;

14
00:00:44,278 --> 00:00:46,817
both leave the original file in place.

15
00:00:47,417 --> 00:00:51,738
Open the new spreadsheet and confirm the two fictional task IDs

16
00:00:51,738 --> 00:00:55,273
are there and Budget is absent. Inspect any formulas.

17
00:00:55,273 --> 00:00:59,594
A copied sheet may contain references to another tab or the

18
00:00:59,594 --> 00:01:03,915
source file; fix those references or replace them with approved static

19
00:01:03,915 --> 00:01:05,486
values before giving access.

20
00:01:06,086 --> 00:01:10,451
Use the Share control on the new spreadsheet, not the original.

21
00:01:10,451 --> 00:01:15,212
Keep General access restricted unless your actual use requires a wider audience.

22
00:01:15,212 --> 00:01:19,577
Add an authorized recipient only after you have checked the copied

23
00:01:19,577 --> 00:01:21,958
data and the intended permission level.

24
00:01:22,558 --> 00:01:25,579
Compare the two file URLs and Share dialogs.

25
00:01:25,579 --> 00:01:30,488
The new file may be accessible while the source file should remain restricted.

26
00:01:30,488 --> 00:01:34,642
The owner view cannot prove what a recipient sees; use a

27
00:01:34,642 --> 00:01:39,551
permitted recipient-side or signed-out check before claiming the original is inaccessible.

28
00:01:40,151 --> 00:01:44,102
The outcome is a separate Status spreadsheet with task IDs one

29
00:01:44,102 --> 00:01:49,130
oh one and one oh two, no Budget tab, and no private source references.

30
00:01:49,130 --> 00:01:50,567
Share only that file.

31
00:01:50,567 --> 00:01:54,159
If you cannot test the recipient perspective, record the permission

32
00:01:54,159 --> 00:01:57,751
boundary as not yet verified rather than assuming it worked.