When I run my google app script, which used to work fine, I keep getting the error message
"This document is too large to be edited offline. Go online to resume editing."
After this message, I close the Google sheet and try to reopen but it won't let me for about 10 minutes. I have no idea why this is happening and how to fix it. Can anybody help me?
I think the problem is caused by the following code that shifts rows down and inserts a row at the top of a Google Sheet:
sheetLog.insertRows(2, 1);//shift all rows down (in history) by length of log
sheetLog.getRange(2,1,1,logResults[0].length).setValues(logResults);