Question about data refresh

leopardhawk

Active Member
Joined
May 31, 2007
Messages
428
Office Version
2016
Platform
Windows
I have four worksheets in my workbook that I wish to hide. All four are running data refresh via web queries when the file is opened and I am wondering if they will still be able to do that if the sheets are hidden? Unfortunately, I can’t test it because the updates are year-end and I would like to know now if this will work or not.

Thanks!
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

jmacleary

Well-known Member
Joined
Oct 5, 2015
Messages
956
Office Version
2007
Platform
Windows
They should all refresh whether or not the sheets are visible, however, I would suggest you put some form of question/answer in the open code to seek confirmation that you want it to refresh, if the data is that time-critical.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,896
Messages
5,471,361
Members
406,758
Latest member
Antsnetswprk

This Week's Hot Topics

Top