Excel - How do I cancel an XLQUERY?

Asked By Bar

13-Apr-07 09:16 AM

I am trying to open a file that was created by another user no longer with
the company.  When I open the file I get the following message:

each time "[file name]worksheet name with in the file" is opened.

This comes up each time I open the file and I want to get rid of it.  How do
I do that?

15-Apr-07 05:16 PM

I’m assuming you get this error when you open the Excel file.

There are two files.  The Excel file and the Query file.  The Query file
extension is .dqy.

The Query file is by default stored in a hidden file on the computer where
the Query was originally written.  The path is:

C:\Documents and Settings\richard.brown\Application Data\Microsoft\Queries

In my case richard.brown above is my name and refers to my computer profile.
You would put your profile name there.

If the Excel file was emailed to you or otherwise copied to our computer
then you don’t have the Query file and therefore can’t cancel or otherwise
use the Query file.
Even if both files were put on your computer you still couldn’t as the path
is pointing to the original creators path.

If you still need the Query file then you must get it from its hiding place.
If on the other hand you just want to cancel the Query from running the only
way I would know how to do this is to create a new profile on your computer
and recreate the same path as the original Query and then create a Query with
the same name and then you can cancel the Query.

There must be a way to easily change the path but I don’t know how.

Good luck.

Richard

16-Apr-07 02:24 AM

Richard

This is the MSQuery add-in from xl97.  I would try first of all,if you have
a version of xl after 97 re-running install and doing a full NOT typical
install

If not, check here

http://support.microsoft.com/kb/173321

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk