Is it possible to write a script or is there another method of backing up a spreadsheet when opened?

The reason is: I have other users opening my spreadsheets and if they completely stuff everything up I want to be able to go to a backup created when they first opened my doc.

  • Thank you I was not familiar with this feature. :-| Still learning!! – Sarah Brereton May 20 '15 at 2:37
  • No problem. I turned my comment in an answer, so that you can accept it (and this thread gets an 'answered' status). – JPV May 20 '15 at 6:56

Check out the built-in revision history, that's available in both the spreadsheet and the script editor under the first menu option (File).

Read the Google Help for more info: revision history

|improve this answer|||||

Your Answer

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

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