Excel version 3 (1990)

  • Thread starter Thread starter Jessica
  • Start date Start date
J

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
 
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.
 
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.
 
Back
Top