2

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?

Improve this question
2
  • 2
    Why don't you want your colleague to know these formulas?
    – tom
    Commented Oct 10, 2014 at 17:04
  • Related: Make formulas impossible to find / read.
    – G-Man
    Commented Oct 10, 2014 at 17:45

1 Answer 1

Reset to default
1

There is no way to block the download option of a shared Google spreadsheet for editors, it's only possible to block viewers and commenters from doing this.

Also there is no way to block the access to the formulas.

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

Another alternative is to create an add-on to replace the job done by the formulas for scripts.

References

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.