I have over 40 tables in my app and a google script to make a back up copy ever so often. The script stopped working yesterday morning. I can’t make a copy manually when in the googlesheet or from the sourde file in the google drive.
I get this error:
Google Docs encountered an error. Please try reloading this page, or coming back to it in a few minutes.
To learn more about the Google Docs editors, please visit our help center.
We’re sorry for the inconvenience.
- The Google Docs Team
I have identified the sheet and column responsible. If I delete the Order Id Column form the “order details” table then the sheet will copy otherwise it won’t. There is no formula or anything - just the order id written to the spreadsheet.
I had to create a new column and copy and paste the data and change a few formulas to get it working.
It seems as though there was somthing in the column that it didn’t like.
I found the offending sheet by downloading the googlesheet as excel. When is opened it up it showed errors on certain sheets. One of which was my order details. Then I delete various columns and tried copying to find the column stopping it.
I still don’t lnow why thos happened.