I agree this is a stupid limitation of Excel. Another workaround could be to break the data up in LabVIEW and send send it in multiple chunks. Each chunk can be placed into a separate sheet.
Michael Aivaliotis <http://forums.lavausergroup.org> > >I want to tell excel from LabView to open or import large > data file. > >The data doesn't fit on a single excel worksheet (65500 rows). are > >there any techniques I can use (using Excel macro or > labview) so that > >when one sheet is filled the program opens another sheet > until the file > >is open completely. > > Well with a lot of VBA code stuffed in a macro you should be > able to do that. But in fact most other spreadsheet > applications out there do not have this stupid limitation. Or > you could use Diadem.
