Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Disable QueryTable Refresh prompt for good?

Status
Not open for further replies.
Chopsaki

Chopsaki

Programmer
Nov 21, 2001
85
US
I have made this monolythic spreadsheet that uses a bunch of stuff to get data. One of the methods it uses is querytables. This is pretty annoying though. Everytime the worksheet is opened excel prompts to refresh the querytables, I will never need this done as it is automated and the data doesn't even come from a db but rather a disconnected RS handed via a COM dll. Is there anyway to stop excel prompting with this msg?
 
Sort by date Sort by votes
If you want to totally disallow refreshes, you can use this code in your workbook_open() event procedure:
Worksheets("myworksheetname").QueryTables(1).EnableRefresh = False
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Solved
Combine two working macros into one for MS Word 1
Replies
7
Views
525
strongm
strongm
MattGreer
  • Locked
  • Question
Excel 365 VBA - Prompt the user to take some action, then wait? 1
Replies
5
Views
185
MattGreer
MattGreer
thanhthanh12
  • Locked
  • Question
How disable save and save as in word vba?
Replies
1
Views
120
macropod
macropod
sxschech
  • Locked
  • Question
For Each Loop works once then gives error 91 2
Replies
19
Views
355
sxschech
sxschech
PWD
  • Locked
  • Question
Good afternoon, I have a Pivot Tabl
Replies
1
Views
72
PWD
PWD

Part and Inventory Search

Sponsor

Back
Top