Export Excel Problem

ericleungnavericleungnav Member Posts: 11
I am using the original export to excel icon in navision for exporting a table of data.

Once I push the button, it warns me that I should set the max. record to be exported higher.

After I have set the max. to a higher number, when exporting, it seems that ms excel warns me that there is a worksheet setting error, would anyone help me to solve the problem?

Many Many thanks.

Comments

  • kinekine Member Posts: 12,562
    It depends on the row count and used Excel version. Older Excels had only max 32K of rows, Excel 2007 have max 1048576 rows... (1M)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.