I get a prompt that says the system could not locate XLQUERY

Asked By qaser 0 points N/A Posted on - 01/02/2012

When I get a prompt that says the system could not locate XLQUERY when I try to access a file, and that pursuing further might lead to inaccuracies; where in the process did I make a mistake and what are steps I can take to resolve this problem?

• Status: Open
• Question Views: 1034
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: ProgScripting Languages

Answered By Crawly math 5 points N/A #82047

I get a prompt that says the system could not locate XLQUERY

Yes, many people face this XLQUERY problem.

The XLQUERY.xla file is located in C: drive > Program File >Microsoft Office >Office11 >Library>Msquery.

The probable causes are:

• This file has been damaged.
• The file is attacked by Virus or Trojan.
• The file has been removed.  
• The excel file you are working is saved or created in Excel 5.0/95 format.  When this happens, excels files query job is unable to access the XLQUERY file in a proper manner. Thus, an error is generated regarding XLQUERY file.

My suggestions are:

• In case of damage, reinstall office program or excel program again.
• Reinstall Windows and antivirus. Scan the whole PC with the antivirus and install office program.
• Make a backup of XLQUERY.xla from C: drive > Program File > Microsoft Office > Office11 > Library > Msquery. When the file is damaged or missing again, just replace it from the backup.
• Save the excel file in the current version’s excel format.

Regards

Crawly Math

About Crawly math

Questions
2

Answers
89

Best Answers
29

• Vote Up 0 Vote Down

• Posted on - 01/02/2012
• Question Category: ProgScripting Languages