Error -41106 When Read data from Excel File

[Josephhaim00]

When reading data from excel file with labview 2017 (32bit) I get the error code: Error -41106.

Week ago everything worked properly.

I uninstall and install Office again.

what can I do to make it work again?

Regards,

Joseph.

Windows 10 Home

Office Professional Plus 2016

Labview 2017 32 bit

[Gregory]

Take a look at this link and double check that your registry keys are correct:

https://knowledge.ni.com/KnowledgeArticleDetails?id=kA00Z000000P82QSAS&l=en-US

Did you install any new MS Office software lately?

[Josephhaim00]

I already saw the NI help on the error.

I made both solution (reinstall office and verify the registry)

I also compared the registry with another computer with the same office and labview developpement kit, everything seem to be right.

the last thing I can try is to reinstall labview.

without understanding the problem source, we still stay with the problem... it cant be a solution to reinstall Labview/office everytime.

If someone have another solution it ll help a lot ! 

Regards,

Joseph.

[Bob_Schor]

It is very difficult to diagnose your problem without more information.  It would greatly help us to help you if you would attach (a) the LabVIEW code (all of the VIs necessary to generate the error you are seeing) and (b) the Excel File that you are trying to read.  It would also be helpful to know what version Excel you are using.

Another thing to check is your LabVIEW License.  The Report Generation Toolkit has its own license, and if you have been using an "Evaluation" license, it might have expired.  To do this, open the NI License Manager and look at the "Local Licenses".  You should see the RGT in there.  Be sure it has a Green Dot and its status is "Licensed".

Bob Schor 

[Josephhaim00]

Hi,

a) see attachment.

b) creating new excel file also give the same error. (see .vi file).

Error number on RGT unlicensed is: -41007 

Error -41007 occurred at NI_report.lvclass:New Report.vi -> Untitled 1.vi

Possible reason(s):

NI-Reports: You must have the LabVIEW Report Generation Toolkit for Microsoft Office installed to create this type of report. The toolkit must also have an activated license or be in evaluation mode.

Excel Version: 2016 MSO (16.0.11901.20170) 64bit

Regards,

Joseph.

[Josephhaim00]

Hi,

I found a solution: when using Labview 32 bit I get the error :-41106 

If I open the same .vi with labview 64 bit i don't get the error anymore.

it seem to be an error using different format system (32bit and 64bit together).

so I renew my question: How can I run vi running with labview 32 bit and Office 64 bit ?

Regards,

Joseph.

[Josephhaim00]

Hi,

Explanation from NI website: https://knowledge.ni.com/KnowledgeArticleDetails?id=kA00Z0000019KZNSA2&l=en-IL

Regards,

Joseph.