刷新/加载电子表格时，公式始终会重新计算 [英] Formulas always recalculating when refreshing/loading spreadsheet

问题描述

每次刷新电子表格标签时，公式都会重新计算.由于数据没有更改，并且以前已经加载了公式，因此不完全确定为什么会发生这种情况.

Anytime I refresh my spreadsheet tab, the formulas begin recalculating. Not entirely sure why this is happening since the data has not changed, and the formulas have previously been loaded.

如何停止此操作?

我的电子表格设置设置为每隔一小时刷新一次.

My spreadsheet settings are set to refresh on change and every hour.

推荐答案

目前看来您无法停止重新计算.似乎只有不断变化"，每分钟变化"和每时每刻".

It doesn't look like you can stop a recalculation at this time. "On change", "On change and every minute", and "On change and every hour" seem to be the only options.

这是2017年的链接:

Here is a link from 2017:

https://productforums.google.com/forum/#！topic/docs/lTs0qvC6m8s; context-place = forum/docs

这篇关于刷新/加载电子表格时，公式始终会重新计算的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！