hasanlianar
New Member
- Joined
- Jul 21, 2011
- Messages
- 43
Hello,
In an Excel sheet I have multiple tables created based on data taken from multiple web sources.
I want to refresh all tables pediocially (every 5, 10 or 30 minutes) to have fresh data.
To do this, I used "From Web" option under "Get And Transform" group in Excel 2016, created multiple tables (based on web data) and wrote a VBA code to auto refresh All tables every 10 minutes. Though, as macro runs constantly Excel sometimes is stuck and freezes.
I also consider using "Refresh every ... minutes" under Connection Properties. How can I use this feature to refresh multiple tables at the same time?
I think it is a better option rather than running macro constantly.
In an Excel sheet I have multiple tables created based on data taken from multiple web sources.
I want to refresh all tables pediocially (every 5, 10 or 30 minutes) to have fresh data.
To do this, I used "From Web" option under "Get And Transform" group in Excel 2016, created multiple tables (based on web data) and wrote a VBA code to auto refresh All tables every 10 minutes. Though, as macro runs constantly Excel sometimes is stuck and freezes.
I also consider using "Refresh every ... minutes" under Connection Properties. How can I use this feature to refresh multiple tables at the same time?
I think it is a better option rather than running macro constantly.