Excel stopped working

[jyang72211]

In my labview program, I open, edit, and close multiple excel sheet one at a time.  It used to work, but I am getting a -41106 error.  It said that the possible reason is "Report Generation Toolkit: Microsoft Word or Excel did not open.  Make sure Microsoft Word or Excel is installed".  I am not what happened.  MS office is definitely installed in my laptop.  The error happens in the node when I tried to open the excel workbook.

[MarcoMauri]

Try running the example "ActiveX Event Callback foe Excel" shipped with Labview.

Does Excel open?

Marco

[jyang72211]

I had to put excel open in loop and keep trying.  It will open within 5 tries.

[MarcoMauri]

Maybe Excel is taking too much time to start (just guessing)...

If Excel is already running does your original program run? Or do you still get error -41106?

Regards,

Marco

[FraggerFox]

I faced this issue several times when Excel instance doesn't close even after closing it with RGT Close VIs.

When I face this issue, I check if Excel.exe is open in Windows Task Manager and manually close it.

There is also a taskkill command to force kill the Excel.exe using sysexec.

[Process_Systems]

I am not sure if this is related to your problem or not; When I was using an older, slower laptop, I found that it helped greatly if I selected the "visible - false" property on Excel open, so that Excel did not show on the screen. Not having to do the extra work of the video updates for multiple Excel spreadsheets to show on the screen seemed to allow everything to work ok.

For what it may be worth, hope it is of some help to you, Good luck,

Dave