缺少[my_spreadsheet_id]文档(也许已将其删除了吗?) [英] Document is [my_spreadsheet_id] missing (perhaps it was deleted?)

问题描述

有时(实际上它经常发生)我收到文件tIbdnvK2ZBY_7SQ2skESDvg丢失(也许已删除?)"的错误，这显然是不正确的.任何人都可以请问一下这个问题吗?也许对此有一些好的解决方案?

Occasionally (actually it's happening quite often) I'm getting a "Document tIbdnvK2ZBY_7SQ2skESDvg is missing (perhaps it was deleted?)" error which obviously isn't true. Can anyone please put some light to this issue? Maybe some good solution to it?

预先感谢， Łukasz

Thanks in advance, Łukasz

推荐答案

我在定时器上使用了一些脚本，偶尔会出现此错误，当脚本尝试访问的工作表过于忙于计算或处理时，似乎会发生这种情况其他请求(旧的Google表格可能会脱机，有时也会导致此问题).

I have a few scripts working on timers and occasionally get this error, it seems to happen when the sheet the script tries to access is too busy calculating or dealing with other requests (the old Google sheets would go offline sometimes hich caused this too).

在新的Google表格中发生的情况要少得多，并且如果可能的话，降低频率也是很好的-我移到了表单提交触发器，然后在第一个触发器失败的情况下每小时进行一次.

It happens much less with the new Google sheets, and reducing the frequency is good too if possible- I moved to the form submit trigger then an hourly on top in case the first trigger fails.

这篇关于缺少[my_spreadsheet_id]文档(也许已将其删除了吗?)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！