Monarch Classic 14 export fail to Excel

Fidencio Chavez
Fidencio Chavez Altair Community Member
edited December 2022 in Community Q&A

Hello, I'm using Monarch Classic 14 and I have a table with a lot of rows and will not export to Excel and fails because it exceeds the amount of rows.  Can someone suggest another option?  Thanks

Tagged:

Answers

  • CPorthouse
    CPorthouse
    Altair Employee
    edited December 2022

    How many rows are you trying to export?  XLS files are limited to 64K rows (65,536) and XLSX files are limited to 1,048,576 rows.  There is also a column limit.  These are Microsoft Excel limitations and not Monarch.

    If you cannot export to XLSX, I would recommend either a text delimited file (CSV) or maybe export to a database via ODBC or OleDB.

Categories