protecting data in a spreadsheet

  • 1
  • Question
  • Updated 4 years ago
  • Answered
I am attempting to make a menu board using the google spreadsheet gadget. My question is if the spreadsheet is public, if someone gets ahold of the link to it what stops them from changing the prices? Would run into some issues if that were to happen. Can you utilize the ability to set it to be viewed but not edited?
Photo of Patrick Duggan

Patrick Duggan

  • 70 Points

Posted 5 years ago

  • 1
Photo of Neal


  • 61,252 Points 50k badge 2x thumb
When you set the Spreadsheet to be public, you aren't providing editing rights to all potential users that see the spreadsheet. After making this change, you should see "Public on the web - Anyone on the Internet can find and view" in the who has access section.

You would still be able to add individuals to edit the spreadsheet. You can test this out by opening the spreadsheet in an incognito window. You'll note that there will be a line at the top "view only" and the menu will be greyed out.

I hope the above helps.

Photo of Robert Baird

Robert Baird

  • 390 Points 250 badge 2x thumb
How would you protect the spreadsheet so that it only displays on your sign.  In my example I would like to know how you protect confidential data so that it can be accessed but only by a sign I have published.
Photo of Blake Freeman

Blake Freeman, Official Rep

  • 36,116 Points 20k badge 2x thumb

In order to display a spreadsheet on your presentation, it must be set to public. It is not advised to display confidential data to a presentation.