I have made a few useful spreadsheets for my company.

I want to put them on Google Sheets, so my colleagues can use it online to make inputs and get results. But I do not want them to know the formula (some of them are quite complex and took me a long time to compile).

However, Google allows a user to download the spreadsheet once it is shared. And once they have downloaded the file as an Excel file, they can pretty much undo all the protection features I have set up in Google.

So is there a way to allow a user to edit a Google Sheet, but not allow them to download it?

migrated from superuser.com Oct 16 '14 at 14:33

This question came from our site for computer enthusiasts and power users.

  • 2
    Why don't you want your colleague to know these formulas? – tom Oct 10 '14 at 17:04
  • No; This topic appears to be about an online service which means its not actually on topic here at Superuser. Its also not clear what problem your actually trying to solve because the stated problem does not make sense. – Ramhound Oct 10 '14 at 17:13
  • Related: Make formulas impossible to find / read. – G-Man Oct 10 '14 at 17:45

There is no way to block the download option of a shared Google spreadsheet.

Instead save it as another file format or create a Web App.

Prevent viewers from downloading a file - Docs editors Help

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy