Edit SQL in MS Query Without it Executing


S

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
 
Ad

Advertisements

S

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
 
Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top