In this example from pulling into excel from yahoo finance
在这个例子中从雅虎财务拉入excel
under Data Range Properties, there is an option to refresh data every so often. Now, will this keep refreshing the data if the excel sheet is open/closed? My guess is if I open the excel sheet,it cannot be refreshed, but could be wrong.
在“数据范围属性”下,可以选择每隔一段时间刷新一次数据。现在,如果excel表打开/关闭,这会不断刷新数据吗?我的猜测是,如果我打开excel表,它不能刷新,但可能是错误的。
1 个解决方案
#1
0
It will ONLY refresh while the workbook is OPEN
它只会在工作簿打开时刷新
#1
0
It will ONLY refresh while the workbook is OPEN
它只会在工作簿打开时刷新