Which TDM Addin for Excel 2007?

[Frank_Rizzo]

I downloaded what I think is the latest TDM add-in for excel 2007.  When I go to open my file a message comes up saying that my file has more than 65000 rows.  I know the limitation is not in excel 2007.  Will the add-in only load 65000 rows of data? 

[Brad_Turpin]

Hi Frank,

I have used the TDM Excel Add-in with Excel 2007 and have gotten a dialog similar to the one you describe, except that for me it only showed up when I had over a million rows of data.  So I can vouch for the TDM Excel Add-in handling the different row limitations of Excel cleanly.

My recommendation would be to uninstall your current version of the TDM Excel Add-in and install the latest version (2.0.1.1) from the following web site:

http://zone.ni.com/devzone/cda/epd/p/id/2944

Regards,
Brad Turpin
DIAdem Product Support Engineer
National Instruments

[Frank_Rizzo]

Thanks for the reply Brad.  I checked my add-in version, by going to the excel 2007 add-in tab, and clicking on "about" on my TDM tool bar.  It claims to be the latest (2.0.1.1).  On the "root" tab of my workbook the length of my data is reported as 243000. I'm not sure how to proceed.  Any suggestions would be appreciated!  When you saw the dialog box did it say your data exceeded 65000 or 1000000 rows?

[Frank_Rizzo]

One thing I didnt mention is that I am not using the full blown version of excel 2007, I downloaded a trial version to see how the add-in worked with Excel 2007................

[Coal_Man]

Frank,

So the installation of the addin went smoothly?  You did not have to add it in manually like in this KB?

http://zone.ni.com/devzone/cda/tut/p/id/5885

You may want to check the specs on the trial version of excel 2007 that you have.  Did you get this from the web?  I don't know if Microsoft would do this, but sometimes the trial software won't have all of the features of the full version.  I just installed the addin on my machine with full version of excel 2007 and was able to open a TDM file with a million random numbers stored in it. 

A good way to test this would be to just create a spreadsheet file with 100,000 numbers in it, then try to open that in excel just to see if it throws the same error.  That would eliminate the possibility of the addin being to blame.  If the file opens without error, then you may want to check that the addin was installed correctly by referencing the KB linked above.

Have a great day.

[Frank_Rizzo]

Coal....

Installation went smoothly, I did not have to add it manually.  I got the trial version from the Microsoft website.  I created a spreadsheet file as you suggested and it opened with no problem.  I am pretty sure the add-in is installed correctly.  I am going to find someone here with a full version of excel 2007 and see what happens....I'll let you know how it works out.......

[Frank_Rizzo]

Here is what I have found...........

The trial version of Excel 2007 would open a file I created with 65000+ rows.  It would not open a TDM file using the add-in that had more than 650000 rows. I got a copy of the full version of Excel 2007 and it opened the TDM file using the add-in with no problem.

[Coal_Man]

Hi Frank,

If it is an issue with the trial software for Excel 2007, I would like to verify and document it.  Where did you get a copy of the trial software for Excel 2007?  I only have access to the full version.  Thanks.

[Frank_Rizzo]

Here is where I got the trial version...............

http://office.microsoft.com/en-us/excel/FX100487621033.aspx

[Coal_Man]

Frank,

I downloaded the trial version and installed it, but I was unable to duplicate the problem that you had.  It's good that the full version of Excel took care of the problem though.  I will try again to reproduce it, but I'm not sure how much success I will have.