CODEWITHSUNDEEP
google-apps-scriptgoogle-sheets
Ewen
Ewen

Reputation: 401

Google Spreadsheet "The document cannot be modified. Perhaps it has grown too large?" error

I have recently exceeded the 2 million cells of a spreadsheet recently due to a timed script adding too much external data to a sheet.

If I try and load the Spreadsheet in Chrome, Chrome crashes although it does load in Firefox. If I try to delete content in Firefox it either hangs or tells me it is "Trying to Reconnect" or that the spreadsheet is too big.

How do you get your data back?

Upvotes: 4

Views: 3094

Answers (2)

spikeston
spikeston

Reputation: 81

You can restore from Version History. Then offload the data somewhere else and/or fix whatever is causing the spreadsheet to overflow.

Upvotes: 3

Ewen
Ewen

Reputation: 401

The answer is ... you cannot. The only solution I found was copying and pasting chunks out of the offending sheet and pasting it into a new sheet as there appears to be no way to delete or alter any data and have it save. I could also copy other sheets to another spreadsheet so my functionality was intact and I assume I could have rolled back to pre 2 million cell version but I didn't pick this up for a while.

If you are running an automatic process of adding data, keep an eye on the amount of data you are storing!

Upvotes: 3

Related Questions