Skip to first unread message
Ravi Verma
Nov 1, 2025, 7:28:26 AM11/1/25
to Google Sheets Community
Hello Champs,
I am working on a report on Google sheet. I have a sheet named "Data " where i am calculating some data using formulae and need you help to protect and hide so that no other user can view it. The Problem i face is when another user makes a copy of it , the person is able to view the formula which i dont want. Please help.
I am working on a report on Google sheet. I have a sheet named "Data " where i am calculating some data using formulae and need you help to protect and hide so that no other user can view it. The Problem i face is when another user makes a copy of it , the person is able to view the formula which i dont want. Please help.
Alexander Ivanov
Apr 17, 2026, 7:26:51 AMApr 17
to Google Sheets Community
Hi!
You can't do something good in that approach. You need an external execution for hidden calculations.
Swarup Modak
Apr 18, 2026, 3:49:04 AMApr 18
to Google Sheets Community
Hmm.
Maintain 2 google sheets.
First Google Sheet for your own: Prepare report.
Second Google Sheet for others to view: Use IMPORTRANGE function.
IMPORTRANGE Example:
IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Hh2grfB6rp9OQ2yAIu3S5YF_CCFJGwyqPGveABlOZKg/view", "World Cup!A1:D21")
or
IMPORTRANGE("1Hh2grfB6rp9OQ2yAIu3S5YF_CCFJGwyqPGveABlOZKg", "World Cup!A1:D21")
Swarup
Reply all
Reply to author
Forward
0 new messages