Anaplan is not allow my export showing message Excel workbooks cannot support more than 65536 rows?

Options
AbhishekChatterjee14
AbhishekChatterjee14
in Modeling
image.png


Tagged:

Answers

  • rob_marshall
    rob_marshall
    Options

    @AbhishekChatterjee14

    Try changing the export excel file type from xls to xlsx.

  • Misbah
    Misbah
    Options

    @AbhishekChatterjee14

    Or to .csv/.txt

  • JohnnyC
    JohnnyC
    Options

    For further context, .XLS (which is compatible with Excel 97-2003 Workbook) has a limit of 65536 rows. Hence, it is prompting the error - Excel workbooks cannot support more than 65536 rows.

    This is also why other Users from this community is advising you to change to another file type. Hope this is informative.

Categories