Question about data refresh

[leopardhawk]

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!

 

[jmacleary]

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.