Try the example, then check the result.
Download the fictional material and follow the steps below. The video uses English illustrative diagrams; it does not present a live app recording. Product controls may vary by version.
Check the answer before applying the method to your own data. How we review guides ↗
Watch the complete lesson.
The video uses English illustrative diagrams; it does not present a live app recording. English captions. Product menus may differ in your account.
Quick answer. Copy the Status sheet to a new spreadsheet and share only that new file. Hiding or protecting Budget in the original file does not make that tab private to people who can open the original.
Use the fictional practice file and independent answer check. Work in a permitted copy.
Before you start. Open a copy of the fictional workbook with Status and Budget tabs. The practice data is invented. Do not share the original workbook with recipients who should not see Budget.
1. Start with a fictional copy
The practice workbook has two tabs: Status with harmless project tasks and Budget with clearly fictional private amounts. Open a copy in Sheets. Before changing permissions, identify the Status tab as the only material the recipient should see.
Checkpoint: Only Status is intended for sharing.
2. Copy Status into a new spreadsheet
Open the Status sheet tab menu and choose Copy to, then New spreadsheet. Name the result Workshop Status Share Copy. Do not select Hide sheet or Protect sheet as a substitute; both leave the original file in place.
Checkpoint: A new file exists.
3. Inspect the copy before sharing
Open the new spreadsheet and confirm the two fictional task IDs are there and Budget is absent. In the supplied workbook, Status formulas should show On track for TASK-101 and Review for TASK-102. Inspect the formulas as well as their displayed results. A copied sheet may contain references to another tab or the source file; fix those references or replace them with approved static values before giving access.
Checkpoint: Data and references checked.
5. Verify the access boundary
Compare the two file URLs and Share dialogs. The new file may be accessible while the source file should remain restricted. The owner view cannot prove what a recipient sees; use a permitted recipient-side or signed-out check before claiming the original is inaccessible.
Checkpoint: Recipient-side access check required.
Verify the result
The new spreadsheet has the intended Status data and no Budget tab. Check its formulas for links back to the original. Verify its Share dialog includes only the intended access. A signed-out or recipient-side test, when available, must show the original file is inaccessible before making that claim.
If it still does not work
If a formula becomes #REF! or points to the original file, replace it with an approved value or a self-contained calculation before sharing. If the original file was already shared, changing the new file does not revoke that original access; review the original Share dialog separately.
Official sources
- https://support.google.com/docs/answer/1218656?hl=en
- https://support.google.com/docs/answer/2494822?hl=en
Any video panel without a marked actual-app capture is an illustrative diagram of the fictional exercise.
Practice downloads.
The exercise files contain invented information. Save a local copy before editing.