Excel errors that plague Excel users and impede work functionality are many but the ones that temper with the opening of important files and folders containing important and sensitive data in them are the ones that come to limelight rather often and on a regular basis.
One such common excel error goes like this:-
'C:\Program Files\Microsoft Office\Office\Library\Msquery\Xlquery.xla' could not be found. Check the spelling of the file name, and verify that the file location is correct.
One gets to see this particular error message when one opens a file in Microsoft Excel 97
The occurrence of this error message can be traced back to two probable causes:-
• When a Xlquery.xla file is moved from its original folder to another folder
• Opening a file containing a macro referencing the Xlquery.xla add-in
The first thing that needs to be ascertained in this case is that whether the file has been renamed, moved, deleted or whether the file is in a trusted location. One can check this by trying to open the file from the list of most recently used files on the File menu.
Provided below are a few workarounds that one can possibly adopt to avoid this:-
• Select the Xlquery.xla Add-In
• Move the Xlquery.xla Add-In to Its Original Location
To go about the first troubleshooting method click on Add-Ins on the Tools menu in Excel and then click to select the MS Query add-in check box. Just in case if you do not find the MS Query add-in listed in there, click browse to search for the Xlquery.xla file which in most cases in located in the following folder by default: C:\Program Files\Microsoft Office\Office\Library\MSQuery
If you are still encountering the error message or you are unable to find the Xlquery.xla file, then try your hands at moving the Xlquery.xla add-in to its original location. Follow the procedures as stated below.
• Click on Start then point to Programs and then click on Windows Explorer.
• In the Windows Explorer, point to Find on the Tools menu and then click Files or Folders.
• In the Named box, type Xlquery.xla
• In the Look In list, click and select the disk drive that contains the add-in file. Once this is done click on Find Now.
• If the search returns no files, repeat the forth step to search any other disk drives that might be having the add-in file.
• When the search window returns the file, right-click on the Xlquery.xla file icon, and click on copy on the shortcut menu
• In Windows Explorer, click to open the MSQuery folder which by default is located in: C:\Program Files\Microsoft Office\Office\Library\MSQuery (the MSQuery folder may be located in a different path depending on where your Excel is installed)
• In Windows Explorer, click on Paste on the Edit Menu
This should solve the problem and the error message should ideally not show up after this but if the problem and the complications associated with it continues, bank on Stellar Information Systems Ltd, a market leader in data recovery and data protection service and solutions for assistance.
If you are not being able to locate the file that contained the all important data in it, it would surely be a matter of concern for you. Stellar values the time and effort that you might have put in to locate the file but tempering with the system to retrieve the file might have reverse effects on the data contained in it. Many a times gross corruption of the file or nascent virus attacks spell this kind of behavior.
Stellar’s  Excel Recovery  Software is an advanced Excel spreadsheet repair program that repairs and restores damaged Excel / xls files and recovers data from them with flowing ease.
The powerful algorithms that characterize the Excel Repair software scan the complete spreadsheet for every inkling of recoverable data and extracts data without deleting or modifying the original document in the least. On the contrary it presents the recovered files with all their features (Name of the Sheets, Text strings, Integer and floating point numbers, Formulas in different format (all defined formulas), Tables, Hyperlinks, Font color, size, style and font name and so on) intact.
 

John Martin a student of Mass Communication doing research on data recovery software. He is also a freelancer for www.stellarinfo.com

Article Source: http://www.therealarticles.com

Please Rate The Above Article From The Data Recovery Category

5 out of 54 out of 53 out of 52 out of 51 out of 5 

Not yet Rated

Click the XML Icon Above to Receive Data Recovery Articles Via RSS!