Excel version 3 (1990)

[Jessica]

Hi there!

I have an access 97 macro that outputs to excel and is defaulting to the
earliest version in the list, excel 3. I can't seem to find anywhere the
number of rows in Excel 3. Does anyone know? same as lotus was ~8,100

~Jessica

 

[Harald Staff]

Hi Jessica

I believe it's 16K (16384) up until Excel97.

HTH. Best wishes Harald

 

[Jessica]

I don't think so b/c I get this message when trying to export 8687 rows:
There are too many rows to output, based on the limitation specified by the
output format.

 

[Dave Peterson]

I used xl2003 to test this.

I started a new workbok with a single worksheet. I filled column A (rows
1:65536) with "asdf". I saved that file as an excel 3.0 worksheet.

I closed the file and reopened. The data stopped with row 16384.

I remember using an old addin to retrieve data from an AS400 (I think) that
would stop at 8192 rows. Just because it was written that way.

I wouldn't be surprised if the real problem was with the addin--not the format
that it's saving the data.