如何禁用Google表格上的自动重新计算? [英] How can I disable automatic recalculation on google sheets?
问题描述
简化方案:
Sheet Customer_Orders,具有行块,每行具有产品代码,订购数量和大小.在这三个花絮的基础上查找/计算其他一堆东西.到该季节结束时,此工作表已包含约5000行.
Sheet Customer_Orders, has blocks of rows with each row having product code, count ordered, and size. Bunch of other stuff is looked up/calculated on the basis of these three tidbits. By the end of the season this sheet has about 5000 rows.
Sheet Raw_Inventory的前500行为年初,然后对Customer_orders进行查询.到季节结束时,此表大约有2000行.
Sheet Raw_Inventory has start of year in the first 500 rows, and then does a query to Customer_orders. By season end this sheet has about 2000 rows.
据我所知,每次我更改Cust_Orders中3个字段之一时,该查询就会运行.
Near as I can tell, this query runs every time I change one of the 3 fields in Cust_Orders.
Sheet Inv_Status是一个针对Raw_Inventory运行的数据透视表,我再次认为,每次修改Raw_Inventory时,都会重新计算该数据透视表. (还有其他几个使用相同数据的数据透视表.)
Sheet Inv_Status is a pivot table that runs against Raw_Inventory, and again, I think that every time Raw_Inventory is modified, the pivot table is recalculated. (There are a couple of other pivot tables that use the same data.)
结果是,对Cust_Orders进行更改最多可能需要2分钟的时间,而计算量就会增加.
The result is that making a change on Cust_Orders can result in up to 2 minutes while the calculations catch up.
(硬件:Mac Pro,24 GB内存,3.2 GHz,4核;当前版本的Chrome在优胜美地下运行)
(Hardware: Mac Pro, 24 GB ram, 3.2 GHz, 4 core; Current version of Chrome running under Yosemite)
我想做的是以下其中一项:
What I would like to do is one of the following:
- 延长更新之间的时间.
- 能够手动重新计算工作表Raw_Inventory.
部分解决方法:
我创建了一个导入raw_Inventory的新表.该副本用于数据透视表. ImportRange仅每30分钟运行一次.
I've created a new sheet that imports raw_Inventory. This copy is used for the pivot table. ImportRange only runs every 30 minutes.
下一步将用1亿个简单赋值语句替换查询.我希望当我对Cust_Orders进行更改时,它将用查询单行代替查询3000行.
The next step will replace the query with 1 zillion simple assignment statements. I'm hoping that this will replace querying 3000 lines with querying a single line when I make a change in Cust_Orders.
推荐答案
无法在Google表格中禁用自动重新计算.一种选择是通过将值仅替换为复制/粘贴或使用脚本来用值替换公式.使用脚本的好处是,还可以在需要时使用脚本再次添加公式.
There is no way to disable automatic recalculation in Google Sheets. One option is to replace the formulas by the values either by using copy/paste as value only or by using a script. The advantage of using a script is that it also could be used to add again the formulas when needed.
相关
- Ho do I stop and start autoupdating in Google Sheets?
- Formulas always recalculating when refreshing/loading spreadsheet
这篇关于如何禁用Google表格上的自动重新计算?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!