Google Spreadsheet“该文档无法修改.也许它太大了?"错误 [英] Google Spreadsheet "The document cannot be modified. Perhaps it has grown too large?" error

问题描述

由于定时脚本向工作表中添加了过多的外部数据，最近我已经超过了电子表格的200万个单元格.

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.

如果我尝试在Chrome中加载电子表格，尽管Chrome确实已加载到Chrome中，但Chrome崩溃.如果我尝试删除Firefox中的内容，则它会挂起或告诉我它是尝试重新连接"，或者电子表格太大.

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.

如何获取数据?

推荐答案

答案是……您不能. 我发现的唯一解决方案是从有问题的工作表中复制并粘贴大块，然后将其粘贴到新工作表中，因为似乎无法删除或更改任何数据并将其保存. 我还可以将其他工作表复制到另一个电子表格，这样我的功能就完好了，并且我认为我可以回滚到200万之前的单元格版本，但是我有一段时间没有使用它了.

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!

这篇关于Google Spreadsheet“该文档无法修改.也许它太大了?"错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！