Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Export Excel observation limits

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

    Code:
    . 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?

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

    Comment


    • #3
      William Lisowski well that definitely explains it.

      Comment


      • #4
        Originally posted by William Lisowski View Post
        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.

        Comment

        Working...
        X