From 04:00 PM CDT – 08:00 PM CDT (09:00 PM UTC – 01:00 AM UTC) Tuesday, April 16, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

TDMS Excel Add-in 18 Crashes Excel 2013

I upgraded a couple of computers today to LabVIEW 2018 using the May 2018 Developer Suite.  After the install I noticed that if I double clicked on a TDMS file, Excel would open, start importing it, and then I would get an error from Windows saying Excel had crashed.  The TDMS file is fine, and can be opened in the TDMS Viewer, and imports fine if I uninstall the version 18.0 of the Add-in and reinstall version 17.0.  No error text file was created in the same folder as the TDMS file.  And if I relaunch Excel it has a file recovery dialog where I can recover the half imported TDMS file.  I've also seen this two other computers all using the same version of Excel 2013 some on Windows 7 x64, some on Windows 10 x64.  Same issue on several different TDMS files.  For now I just have been uninstalling 18 and reinstalling 17.  Can anyone else reproduce this issue?  Thanks.

0 Kudos
Message 1 of 11
(4,008 Views)

I will recommend you to contatc NI support, since not all people is using LV 2018 , it might be an issue with the software, but I have not reproduce the issue.

0 Kudos
Message 2 of 11
(3,965 Views)

Hi, I installed LV 2018, and try to open a TDMS file, but I dit not see the behaviour you mentioned therefore, I would like to know if you can provide me with a little bit more information:

 

1.Does this happens on all TDMS files? Or just with big ones?

2. What do you men by "uninstall the version 18.0 of the Add-in "

3. Have you checked on other office versions?

 

Please let me know so I can continue reproducing it, as I mentioned, I have not been able to reproduce it, it work fine for me, but I might be doing something different than you.

0 Kudos
Message 3 of 11
(3,928 Views)

1.  Not all TDMS files, just the important ones.  I suspect it has something to do with the format of the data we are flattening.  The file is quite small.  Attached is one such TDMS file that crashes Excel 2013 with version 18.0.

 

2.  I mean I uninstalled version 18 of the Add-in by going through NI's uninstaller which is found in the Add/Remove Programs.  If I re-install version 17.0 it opens just fine.  18.0 crashes every time.

 

3. I only have access to this version of Excel at the moment.

0 Kudos
Message 4 of 11
(3,922 Views)

I was actually able to reproduce the same issue you are experimenting with LV 2018 using your TDMS file, what are the main differences between this TDms file and the ones that does not have the issue.?

0 Kudos
Message 5 of 11
(3,887 Views)

The files that are crashing Excel, appear to be ones that have a relatively large amount of data in single properties on channels.  For instance the Property "Type" for the Virtual Sensor Chennel in the Battery Settings Group has a value of:

 

Spoiler
398 16464 5 212 16464 5 26 16432 -1 -1 4421 28263 26990 25888 18788 25966 29801 26217 25970 40 16448 1 -1 -1 8 48 -1 -1 5459 29793 29801 25376 17519 30050 27749 8275 25966 29551 29299 40 16448 1 -1 -1 8 48 -1 -1 5459 29793 29801 25376 21364 29289 28263 8275 25966 29551 29299 42 16448 1 -1 -1 8 48 -1 -1 5700 31086 24941 26979 8260 28533 25196 25888 21349 28275 28530 29440 42 16448 1 -1 -1 8 48 -1 -1 5700 31086 24941 26979 8275 29810 26990 26400 21349 28275 28530 29440 3926 26994 29813 24940 8275 25966 29551 29299 42 16448 1 -1 -1 12 16387 1870 30061 25970 26979 4947 29793 29801 25376 17519 30050 27749 8265 28260 25976 42 16448 1 -1 -1 12 16387 1870 30061 25970 26979 4947 29793 29801 25376 21364 29289 28263 8265 28260 25976 44 16448 1 -1 -1 12 16387 1870 30061 25970 26979 5188 31086 24941 26979 8260 28533 25196 25888 18798 25701 30720 44 16448 1 -1 -1 12 16387 1870 30061 25970 26979 5188 31086 24941 26979 8275 29810 26990 26400 18798 25701 30720 1859 27765 29556 25970

 

0 Kudos
Message 6 of 11
(3,882 Views)

I wil proceed to fill a corrective action request, to report this behavior, thanks for your feedback. 

0 Kudos
Message 7 of 11
(3,860 Views)

When you get a CAR # can you post it here so it can be tracked in release notes.

0 Kudos
Message 8 of 11
(3,856 Views)

Thanks Again, CAR number 700825

Message 9 of 11
(3,830 Views)

LabVIEW 2018 SP1 was released (tomorrow?), and with it is a new version of the TDM Excel Add-in version 18.0.1 (separate download here).  My issue appears to be fixed with this importer on my TDMS files with this version.

0 Kudos
Message 10 of 11
(3,604 Views)