+ Reply to Thread
Results 1 to 5 of 5

Disable "Query Refresh" prompt

  1. #1
    Registered User
    Join Date
    09-26-2009
    Location
    ontario canada
    MS-Off Ver
    Excel 2003
    Posts
    64

    Disable "Query Refresh" prompt

    I would like to disable the "Query Refresh" (Enable automatic refresh/Disable automatic refresh) prompt that appears when I open my work book that imports data.
    Last edited by pdmkh; 09-28-2009 at 09:23 AM.

  2. #2
    Forum Expert
    Join Date
    01-03-2006
    Location
    Waikato, New Zealand
    MS-Off Ver
    2010 @ work & 2007 @ home
    Posts
    2,243

    Re: Disable "Query Refresh" prompt

    hi,

    Welcome to the Forum

    You may (I couldn't because my connection timed out) find something of interest under: http://www.google.co.uk/url?sa=t&sou..._SWuxjndIE5DBw
    or try this link to Peo's suggestion: http://www.tech-archive.net/Archive/...4-12/2680.html

    hth
    Rob
    Rob Brockett
    Kiwi in the UK
    Always learning & the best way to learn is to experience...

  3. #3
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: Disable "Query Refresh" prompt

    You may (I couldn't because my connection timed out) find something of interest under: http://www.google.co.uk/url?sa=t&sou..._SWuxjndIE5DBw
    I successfully set this up so long ago I'd forgotten, recommended given usual caveats re: fiddling with the registry

  4. #4
    Registered User
    Join Date
    09-26-2009
    Location
    ontario canada
    MS-Off Ver
    Excel 2003
    Posts
    64

    Re: Disable "Query Refresh" prompt

    Thank you very much!! Problem solved. The link you provided was excellent.

  5. #5
    Forum Expert
    Join Date
    01-03-2006
    Location
    Waikato, New Zealand
    MS-Off Ver
    2010 @ work & 2007 @ home
    Posts
    2,243

    Re: Disable "Query Refresh" prompt

    Thanks for the feedback & marking the thread as solved - I'm pleased we could help :-)
    Feel free to add to our reputations by clicking on the blue scales at the top right of our posts - it is appreciated.

    Rob

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1