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.

从电子表格外部提取数据的功能在以下时间重新计算:
ImportRange: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屋！