IMPORTRANGE 多久刷新一次? [英] How frequently does IMPORTRANGE refresh?

问题描述

importrange 函数刷新和重新加载的频率源数据?

How frequently does the importrange function refresh and reload the source data?

推荐答案

关闭时

Never.Spreadsheets 仅在 onOpen() 上更新外部 api.但是没有文档，这在未来可能会改变.

When closed

Never.Spreadsheets update external api only onOpen(). But there is no documentation and this may change in the future.

从电子表格外部提取数据的函数在以下时间重新计算:
导入范围:30 分钟
ImportHtml、ImportFeed、ImportData、ImportXml:1 小时
GoogleFinance:最多可能延迟 20 分钟

Functions that pull data from outside the spreadsheet recalculate at the following times:
ImportRange: 30 minutes
ImportHtml, ImportFeed, ImportData, ImportXml: 1 hour
GoogleFinance: may be delayed up to 20 minutes

打开电子表格会刷新所有功能.

Opening the spreadsheet refreshes all the functions.

这篇关于IMPORTRANGE 多久刷新一次?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！