Export Excel observation limits

[wbuchanan]

Wasn't sure if anyone else has run into this, but just tried exporting part of a file and got an interesting error:

. export excel using attnd2008.xlsx if endYear == 2008, datestring("%tcCCYY-NN-DD_HH:MM:SS") replace first(var) miss("")
observations must be between 1 and 1048576
r(198);

Not sure if this is an MS Excel limit or something else and was wondering if anyone else had run into the same issue?

[William Lisowski]

Google tells me that that is the maximum number of rows in an Excel spreadsheet starting in Excel 2007.

[wbuchanan]

William Lisowski well that definitely explains it.

[Monica White]

Google tells me that that is the maximum number of rows in an Excel spreadsheet starting in Excel 2007.

Indeed. That is the (un)magical number of allowed rows (observations) for an excel sheet.