Google表格卡住了，无法更新，有太多旧版本? [英] Google Sheet Stuck and unable to update, too many old versions?

问题描述

TLDR:

我们的Google电子表格已损坏，无法编辑/保存.它一直在说试图重新连接.要离线编辑，请在重新连接和重新连接时打开离线同步.可能是由于保存了许多版本吗?如果是这样，如果我们不希望工作表更改其ID，该怎么办?

Our Google Spreadsheet is broken and cannot be edited / saved. It keeps saying Trying to reconnect. To edit offline, turn on offline sync when you reconnect, and Reconnecting. Can it be due to the many versions saved? If so, what can be done if we don't want the sheet to change its ID?

我们非常感谢您的帮助！

Any help is highly appreciated!

详细背景:

我们的项目中有一个很大的Google Spreadsheet(小于70万个单元格)，并且远远低于

We have a large Google Spreadsheet in our project (< 700k cells) and it's well under the 2 million cells size limit as described in here .

我们一直在以编程方式更新此工作表，方法是使用python在google驱动器中创建CSV，然后使用Google App脚本用CSV中的内容更新工作表.

We have been programmatically updating this sheet by creating CSVs in the google drive with python, then using Google App Script to update the sheet with contents from the CSVs.

已经好几个星期了，今天我们开始遇到一个问题，那就是，当我们手动打开工作表时，它一直在说:尝试重新连接.要离线编辑，请在重新连接时打开离线同步"和重新连接".我们无法更改工作表.

It has been fine for several weeks, today we started to have an issue, that is, when we manually open the sheet, it just keeps saying "Trying to reconnect. To edit offline, turn on offline sync when you reconnect", and "Reconnecting". We can make no changes to the sheets.

我们尝试使用不同的浏览器(chrome，firefox，edge)和不同的操作系统(Windows，Mac)，但仍然存在相同的问题.因此，我认为这与防火墙/浏览器配置无关.

We tried to use different browsers (chrome, firefox, edge) and different OS (Windows, Mac), and we still have the same issue. So I don't think it's anything related to firewall / browser configuration.

我们尝试制作工作表的副本，并且能够对副本进行更改.我们还可以访问任何其他工作表并进行更改，而不会出现任何问题.

We tried to make a copy of the sheet, and we are able to make changes to the copy. We can also access any other sheets and make changes without any problem.

实际工作表和复制的工作表之间的唯一区别可能是实际工作表有很多旧版本(每3分钟更新一次，持续数周).那可能是编辑失败的原因吗?

The only difference between the actual sheet and the copied sheets is probably that the actual sheet has a lot of old versions (it has been updated every 3 minutes for weeks). Can that be a reason of failure to edit?

另一种可能性是，许多其他脚本也会阅读此工作表.请问这是为什么吗?(停止所有脚本/将所有脚本重定向到另一个电子表格会很痛苦)

Another possibility is that many other scripts read this sheet. Can this be why? (It will be a pain to stop all the scripts / redirect all the scripts to another Spreadsheet)

非常感谢！

其他详细信息/结论:

• 对于如此大规模的数据集，使用数据库绝对比电子表格更好.

• Using a database is definitely a better idea than a spreadsheet for such a large scale dataset.

使用了".edu"域.我相信我们正在使用G Suite版本.

An ".edu" domain was used. I believe we are using the G Suite version.

就像PC机壳一样，当我在Android上使用移动版本时，我无法进行任何更改.

Just like the PC case, I am unable to make any changes when I use mobile version on Android.

从各种来源看来，旧版本似乎无法删除( http://www.sevenminutescientist.com/2016/06/03/no-you-cannot-remove-a-revision-history-from-a-google-doc/)

From various sources, it seems that the old versions cannot be deleted (http://www.sevenminutescientist.com/2016/06/03/no-you-cannot-remove-a-revision-history-from-a-google-doc/)

当我查看版本历史记录时，它显示以下内容:"Google文档遇到错误.请尝试重新加载此页面，或在几分钟后返回.我无法访问任何旧版本.

When I look into the version history, it shows the following: "Google Docs encountered an error. Please try reloading this page, or coming back to it in a few minutes." I am unable to access any of the old versions.

推荐答案

Google云端硬盘出现问题，导致您在Chrome中不断断开连接吗?错误消息:正在尝试连接.要离线编辑，请在重新连接时打开离线同步"

Having issues with Google Drive constantly disconnecting you in Chrome? Error message: "Trying to connect. To edit offline, turn on offline sync when you reconnect"

在运行Windows 10 64位和Google Chrome(在32位和64位版本中发生)的PC上遇到此问题.在Firefox中似乎没有发生.

This issue was encountered on a PC running Windows 10 64bit and Google Chrome (happens in the 32-bit and 64-bit versions). It doesn’t appear to happen in Firefox.

原因:卡巴斯基SSL扫描(尽管在Chrome中这可能仍然是一个问题，因为它在其他浏览器中不会发生，并且很可能很快会被其中一方解决)

Cause: Kaspersky SSL Scanning (although it may still be an issue in Chrome as it doesn’t happen with other browsers and will likely be fixed by one of the parties soon)

解决方案:禁用卡巴斯基2015加密连接扫描.设置>附加>网络>禁用加密的连接扫描.注意:即使您通过临时禁用功能禁用了卡巴斯基，Google Docs仍然无法工作，您仍然必须关闭加密连接扫描，因为即使暂时停止了卡巴斯基，加密连接扫描也始终会运行(另一个错误，如关闭卡巴斯基，则应禁用此功能).

Solution: Disable Kaspersky 2015 Encrypted Connection Scanning. Settings > Additional > Network > Disable encrypted connection scanning. NOTE: even if you disable Kaspersky via the temporary disable feature Google Docs still doesn’t work you have to turn off Encrypted Connection Scanning as it’s obviously always running even when Kaspersky is temporarily stopped (another bug as turning Kaspersky off should disable this).

这篇关于Google表格卡住了，无法更新，有太多旧版本?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！