Everyday goals

Share a Few Google Sheets Values Without Sharing the Source File

Published by OneCell

To share a few Google Sheets values without giving someone your source workbook, make a separate, dated summary containing only the information you are authorized to send. Enter the few approved values manually, check them against the source, and share that new file with the intended recipients. Leave the source workbook’s access unchanged.

This method is a snapshot. It does not give the recipient a live view of selected cells, and later source edits will not update it. Use it when someone needs a small checked answer, such as the number of places available for one workshop.

Do not use hidden tabs as the boundary

Hiding the other tabs in a workbook does not keep their contents from its viewers: they may be able to copy the workbook and unhide them. Protected ranges control editing rather than confidentiality. Google explains both limits in its guidance on protecting and hiding sheets.

Instead, decide exactly what this recipient needs before preparing the separate file. A total may be appropriate to disclose even when the individual records behind it are not.

Build a small summary from approved values

Consider a fictional event workbook with three tabs: Event status, Attendee names and Internal costs. A venue contact needs the status of one 24-place workshop. They do not need attendees’ names, internal costs or a link to the workbook.

On a computer, create a new blank Google spreadsheet in a location whose access you can control. Give it a recognizable title, such as Tuesday workshop status — 31 October, and use a tab called Summary. Manually enter only these approved labels and plain values:

  • A1: Tuesday evening workshop

  • A2: Confirmed places; B2: 18

  • A3: Available places; B3: 6

  • A4: Checked; B4: 31 October 2026, 09:00 Toronto time

There is no formula or source link in this summary. Do not duplicate the workbook, copy whole tabs, or bring over names and notes merely to obtain those two counts.

Compare each entry with the source at the stated check time. In this example, 18 confirmed places plus 6 available places equals the workshop’s capacity of 24. Check the event name too: accurate counts for the wrong workshop would still give the recipient a wrong answer.

For other figures, include the unit and reporting period they need. If a count is unconfirmed, say Not confirmed rather than entering zero. Here, zero available places would mean there are no places available; it would not mean the availability check has not happened.

Inspect the file and its access before sharing

Read the whole new file, including every tab, note and link. Check the title as well as the cells. Do not put private information into it and rely on deleting that information afterward.

Check its destination folder: Google Drive files inherit folder permissions, and a file cannot give someone less access than its parent folder. Choose an appropriately limited location rather than assuming a new file starts with the access you want.

For specific-recipient sharing on desktop, follow Google’s file-sharing instructions:

  1. Open the summary’s Share menu and inspect who already has access, including inherited access.

  2. Under General access, use Restricted for this example.

  3. Enter the intended recipient’s email address and choose Viewer.

  4. Check the address, role and file again, then use Send or Share.

Work or school policies may limit external sharing. Do not broaden access to bypass them. Have the recipient confirm they can open the summary using the intended account.

A file’s access settings do not establish permission to disclose its contents. Share only approved information, and do not promise anonymity or that someone cannot retain what they see.

Show what happens when the source changes

At 11:00, two more places are confirmed in the fictional source workbook. It now shows 20 confirmed and 4 available. The shared summary still shows 18 and 6, with its honest 09:00 check time. Reopening it does not fetch the new counts.

If the contact needs the current position, verify the new figures against the source, check that 20 + 4 = 24, then manually update the summary and its check time or issue a clearly dated replacement. Tell the recipient which update to use. A useful message is: “Checked at 11:00 Toronto: 20 confirmed, 4 available. Please use this update instead of the 09:00 summary.”

Do not change the timestamp alone: that would make old figures look freshly checked. Earlier copies may remain, so do not assume a correction recalls information already received.

If someone needs ongoing updates, agree who will check and send them and when. If they need live collaboration or frequent refreshes, choose a separately permissioned workflow suited to that task. This small manual summary is useful precisely when a dated answer is enough.