Wednesday, September 3, 2014

Where Have My Google Spreadsheet Scripts Gone? They're Add-ons or...

Over the last couple of weeks I have received a bunch of emails from readers who were looking for Google Spreadsheet scripts that they used last year, but cannot find this year. The reason for this is that when Google pushed out the updated Spreadsheets to all Google Apps for Edu domains the script gallery was removed from the "insert" menu in Google Spreadsheets. A few of those scripts are now available as Add-ons, but most are not.

Scripts were developed by third party developers. If the developer did not re-write the script to be an Add-on, the script is gone. The work around is if you have an old spreadsheet that has not been updated to the new version of Google Spreadsheets, you may be able to make a copy of that spreadsheet and continue to use the old script. New Visions for Public Schools provides directions for this process in this explanation of how to continue to use the FormLimiter script.