Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've been trying to make the spreadsheet automatically sort some data, and after some searching I found this post: Automatic sorting.

It works just perfect with my permissions as the owner, but when any of my collaborators edit a cell he gets the message You don't have permission for this action.

I found that the problem was that some of the cells in the range to be sorted are "protected" and only I can edit those cells.

So my question is: Is there any way to automatically sort the data and keep the cells protected?

share|improve this question
Scripts that are published as web applications can run as the spreadsheet owner. So, if you could publish the script as a web application, and persuade your collaborators to visit a URL after each edit, they would be able to run the sorting script. But this is hardly automatic. See developers.google.com/apps-script/execution_web_apps – Vidar S. Ramdal Nov 12 '13 at 13:40

I am fighting with the same problem, I think it is because the protected cells are set statically and not affected by the sort. The reason is that Google Spreadsheets do not allow the selection of multiple ranges with are not adjacent to each other.

In other words, If you have a defined protected range in the Spreadsheet, it will always be the same rows and columns, regardless of your actions (adding rows and columns, sorting them and so on).

This is a huge drawback of the Google Spreadsheets.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.