Microsoft Query - Turn of refresh on open

[insanity82007]

Hi guys... microsoft query although useful is also very annoying and slow to modify.

I have spreadsheets that pull data out of an SQL server 2008 DB using microsoft query and every time I want to edit the SQL it insists on running the query when it opens. How do I turn this off? I want to run the query only once I've exited MS Query by refreshing in excel.

 

[jkpieterse]

Check out the datarange properties (right-click anywhere in the query table) and uncheck refresh on open.

 

[insanity82007]

Check out the datarange properties (right-click anywhere in the query table) and uncheck refresh on open.

I thought that was for when excel opens? I'm talking about opening MS Query from excel to change SQL code.

 

[jkpieterse]

Ah, sorry, I misunderstood. What Excel version are you using? If 2007 or 2010, you can edit the SQL directly from Excel in those versions, without the need to use MSQuery at all. FOr 2003 and before, check out my query manager:
http://www.jkp-ads.com/download.asp#querymanager

 

[insanity82007]

Ah, sorry, I misunderstood. What Excel version are you using? If 2007 or 2010, you can edit the SQL directly from Excel in those versions, without the need to use MSQuery at all. FOr 2003 and before, check out my query manager:
http://www.jkp-ads.com/download.asp#querymanager

This is brilliant. Took me a while to figure out where to find it but I got there in the end under the "Tools" menu. Thanks so much!!