stop MS Query from connecting when starting

Giganews Newsgroups
Subject: stop MS Query from connecting when starting
Posted by:  RickH
Date: Sat, 28 Mar 2009

I have several hundred spreadsheets in which I need to edit the query.
It would be much easier if MS Query would simply let me edit the query,
rather than trying to open the data source 1st, which I have no access to,
since my client's network is not accessible.
Right now, I save as XML, edit the strings with notepad, open again in
Excel, save as XLS.
Really painful and error prone.
I just need to change the default startup behavior of MS Query to NOT connect.

Replies