Edit SQL in MS Query Without it Executing

[scott]

Is there a way to prevent MS Query from running the SQL code stored in
the Query window whenever I try to edit it?

Here's what happens when I want to change any part of the SQL
statement which feeds data to my pivot table.

1. Rt-click on the pivot table and choose PivotTable wizard
2. Click on the Get Data Button.
3. Wait roughly 1 hour for the query to run.
4. Make the changes to the query
5. Wait roughly 1 hour for the query to run.
6. Return to the PivotTable and click refresh
7. Wait roughly 1 hour for the query to run.

Is there anyway that I can eliminate steps 3 and 5?

Thanks!
Scott

 

[Guest]

Try this:

http://www.contextures.com/xlPivotPlay01.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[scott]

This solution requires special software to be installed.
Unfortunately, my employer won't allow this. Is there an other
solution you might suggest?

Thanks!
Scott

 

[Guest]

The "special software" is the PivotPlay.xla file, an Excel Add-in with
unprotected VBA code. If you're unwilling to run the xla file, then that
rules out any kind of VBA solution, too. Perhaps you coud save the query
from MS Query (after running it, of course) as a dbq file. then you could
open the query in notepad to edit it.


***********
Regards,
Ron

XL2002, WinXP