Components are damaged or missing - Techyv.com

Asked By louielamst 980 points N/A Posted on - 06/26/2011

qa-featured

Hi,

I am using Microsoft Excel 2003 and I am just new with this job. I was trained to use this type of method last week, but obviously due to time constraint of the training, I was not able to absorb all things in just a glimpse of time.

Most of my entries are character string, and my cells contain a lot of characters. I asked my friend for help, but they don't have an idea on my problem. So I am posting my problem in this site in hope to find solution.

Run-time error '1004': Cannot run 'MSQUERY.EXE'. The program or one of its components is damaged or missing

Run-time error '1004':

Cannot run 'MSQUERY.EXE'. The program or one of its components is

damaged or missing.

I am working with Microsoft Excel doing some arrays that involved large string, I met an error that I pasted above.

Thanks.

Status: Open
Question Views: 3937
Answer Count: 2
Vote Up 0 Vote Down

Answer Accepted: Yes
Question Category: MS Excel

Best Answer by Tim Smith

Best Answer

Best Answer

Answered By Tim Smith 0 points N/A #124867

Components are damaged or missing

qa-featured

Hi,

This error usually occurs when you’re programmatically updating PivotCaches and you get this error "Cannot run 'MSQUERY.EXE"
Despite the fact that MS Query and other programs are running smoothly. This problem arises due to asynchronous updates(when two PivotCaches try to use MS Query at the same time).
To correct this you have to do one simple thing i.e. you have to set pvtCache.BackgroundQuery to false this will make cache run synchronous.

I hope this helps.

About Tim Smith

Questions
0

Answers
6

Best Answers
3

Vote Up 0 Vote Down

Posted on - 07/10/2011
Question Category: MS Excel

Answered By shenna22 5 points N/A #124868

Components are damaged or missing

qa-featured

Hi good day,

This problem is due to the some application copies that were pastes into your Microsoft Excel and also the number of copies that you pasted it in the row of Excel. To resolve this kind of issue please visit this site for more information.

NOTE: Please use Registry cleaner software to clean the registry of your computer or laptop to ensure Excel is working correctly.

Thank you.

Hope this helps.

Regards,

Shenna22

Questions
0

Answers
71

Best Answers
26

Vote Up 0 Vote Down

Posted on - 08/02/2011
Question Category: MS Excel

Login/Register to Answer

The cell writeback operation cannot be committed

Select method of Range class failed