每次打开Excel文件时如何刷新导入的数据？ [英] How do I get imported data to refresh each time the Excel file opens?

问题描述

我有一个模板，用于跟踪多个外部电子表格中的数据。外部电子表格将导入到模板的不同选项卡中。


我知道一旦导入数据，就可以调整连接属性，以便在打开模板文件时刷新数据，但是，这将是繁琐的，因为新的数据导入将是不断增加。


有没有办法让模板文件刷新所有数据而不调整每组导入数据的连接属性？我知道''全部刷新''按钮是另一种选择，但导入的数据每天都在变化，所以这不太理想。

I have a template that will be used to track data across multiple outside spreadsheets. The outside spreadsheets will be imported to different tabs of the template.

I know that once the data is imported, the connection properties can be adjusted so that the data refreshes when the template file is opened, however, this is tedious as new data imports will be added constantly.

Is there a way to get the template file to refresh all data without adjusting the connection properties of each set of imported data? I know the ''Refresh All'' button is another option but the imported data changes day to day so again, this is not ideal.

推荐答案

不是全部刷新刷新所有链接？这怎么不能捕捉到日常变化？我有点困惑。

Doesn''t the "Refresh All" refresh all links? How does that not capture the day-to-day changes? I am a bit confused.

确实如此，但我希望数据自动刷新。我的一些同事将使用电子表格并不熟悉Excel，所以我想尽可能自动化。

It does but I would like the data to refresh automatically. Some of my coworkers who will be using the spreadsheet are not that familiar with Excel so I''d like to automate things as much as possible.

我认为有一个设置可以自动更新电子表格打开时的链接。让我看一下....


可能还有一些方法可以在VBA中以编程方式进行。

I thought there was a setting to automatically update your links when the Spreadsheet was opened, too. Let me look into it....

There might also be some ways to do it programmatically in VBA.

这篇关于每次打开Excel文件时如何刷新导入的数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！