SHARE spreadsheet online but prevent from downloading

[dchew]

What would be the simplest way, lets say i have an excel spreadsheet, would want to share it online for "specific" users to edit it, but restrict them from making copies/download of the file because i would want to keep the formula's to myself.

tried google sheets, but cant do it
tried dropbox, cant do it too

google sheets "editors" can download but can prevent "viewers" from downloading.

i want to be able to provide edit access to my members but not want them to download.

Thanks

[kev_]

It is almost impossible to stop users downloading if they are determined
- they have already downloaded (a temporary copy of) the file when they open it
- editors are required to edit and save the file so that limits your options
- even if they do not save a copy of the file they could copy and paste ("secret" formulas) to another workbook
- you can make it more difficult for editors to access formulas

Some workarounds
To properly protect the formulas from being seen the best way is to put them somewhere that editors cannot access

1
Add extra "hidden" sheets in the workbook and put all "secret" formulas in there
Hide those sheets in a way editors cannot see them (2 ways to do that)
Amend other sheets so that editors see results not formulas
2
Same as above but use a separate workbook for "secret" formulas
Link editors' workbook to the "secret" workbook
Amend other sheets so that editors see results not formulas
3
Use VBA to disable "SaveAs" - to prevent a copy of the file being saved
Use other VBA techniques to control editors
4
Use sheet protection to control editors

Questions
How are you sharing the file?
How are "editors" accessing it?
What type of amendments do editors make?
Are you trying to protect specific formulas from being amended or from being seen & amended?