Google电子表格不断重新计算功能 [英] Google spreadsheet constantly recalculates functions

问题描述

我注意到我的电子表格不断刷新功能 - 我可以看到进度条[右上部分]每5-10秒移动一次。在这些高峰期，我有巨大的处理器消耗。

由于主表中有1100行（该文件中的20个表中有1行），因此很难找到哪个函数使进度条保持运行。 b
$ b

有什么办法可以列出当前正在处理的函数吗？

预先致谢！

干杯！

Pawel

解决方案

从浏览器中尝试开发人员工具。如果您使用Chrome，请如何使用时间轴工具。尝试脱机工作，以便放弃问题与需要在线更新的功能（如IMPORTRANGE和Google Apps脚本）相关。

使用搜索功能和正则表达式一起查找开放式引用（如A：A）和函数，如MMULT，SUMPRODUCT和类似函数。

I noticed that my spreadsheet is constantly refreshing functions - I can see progress bar [right-top section] moving each 5-10 secs. On those peaks I've huge processor consumption.

Since there're 1100 lines in main sheet (1 of 20 sheets in that file) it's pretty hard to find which function keeps progress bar running.

Is there any way to list which function is currently processed?

Thanks in advance!

Cheers!

Pawel

解决方案

Try the developer tools from your browser. If you use Chrome, checkout How to Use the Timeline Tool.

Try to work offline in order to discard that the problem is related to functions that require to be online to be updated like IMPORTRANGE and Google Apps Script.

Use the search function together with regular expressions to look for open-ended references (like A:A) and functions like MMULT, SUMPRODUCT and similar functions.

这篇关于Google电子表格不断重新计算功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！