MS Query Window

[Michelle]

Hello, I have some data in Excel that comes from MS Query, I want to
be able to edit the query in the MS query window. but when I click the
Edit Query button, it makes me step all through the wizard before I
get to the MS Query window.

How do I get straight to MS Query without all the mucking about? There
must be a way of switching the wizard off, you'd think, but I can't
find it.

thanks...

Michelle

 

[Ron Coderre]

The free Pivot Play PLUS add-in, located at
Debra Dalgleish's website, may help:
http://www.contextures.com/xlPivotPlayPLUS01.html

It allows you to view/edit the Data Source and SQL code
for Pivot Tables and Query Tables that use external data sources.
(It has a handful of other features, too)

Is that something you can work with?
Post back if you have more questions.

Regards,

Ron
Microsoft MVP - Excel