Results 1 to 2 of 2

Thread: Question about data refresh

  1. #1
    Board Regular
    Join Date
    May 2007
    Location
    North Vancouver, BC, Canada
    Posts
    275
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Question about data refresh

    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!

  2. #2
    Board Regular jmacleary's Avatar
    Join Date
    Oct 2015
    Location
    at a desk in the UK
    Posts
    551
    Post Thanks / Like
    Mentioned
    13 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Question about data refresh

    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.
    If my answer has helped, please vote using the Thanks or Like buttons on the left.
    John

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •