The Query Cannot be edited by the Query Wizard

[GCB]

Good Afternoon

I wondered if someone out there could help me solve a very annoying problem.
We have two Windows 2003 Terminal Servers which have been setup as a load
balanced cluster. We have Microsoft Office 2003 Professional installed on
each one, it is up to date with all of the latest service packs and patches.

OK now the problem is that we have an Excel spreadsheet which someone who
has left the company has set up, it pulls data from one of our SQL servers
into Excel. If I log into either of the Terminal Servers as the Administrator
and try and edit the query attached to the spreadsheet then I get the Excel
Query Wizard open and everything is fine. If I log on as myself (or anybody
else for that matter) and bearing in mind that I also have administrative
rights then I get the error message "The Query Cannot be edited by the Query
Wizard" I click ok and then MS Query then opens up.

Now the users that are going to be using the spreadsheet don't understand MS
Query and want to use the Excel Query Wizard to do their work, I've tried as
much as I know but to no avail, I believe the issue is a permissions problem
within Excel it's self as the few users that need to access the data from the
database on the SQL server already have the permissions granted. I have also
tried to get one of the users to open up Excel locally (ie. outside of
terminal services) and they do NOT receive this error message and get the MS
Excel Query Wizard like they should.

Any ideas gratefully received???