Excel only allows upto 65000 rows error resolved in NAV 2013

manisharma31
manisharma31 Member Posts: 285
edited 2014-01-02 in NAV Tips & Tricks
When you run Analysis by dimension report & try to export the data in excel using the standard function & if the data is very large you get the error.

Error Message:-
"There are 65000 rows within the filter. Excel only allows up to 65000 rows".

Now the error has been resolved from NAV 2013 onwards.

Now when you use the standard function of export to excel via analysis by dimension report, NAV now checks for the excel version is not less than Ver 12 and No. of Rows is greater than 65000.
Regards,
Manish

Comments

  • srijayk
    srijayk Member Posts: 1
    How this can be handle in NAV 2013. From Report Viewer there is a limit of 65000 rows.
    Is there any patch which will help to resolve this issue.
  • geordie
    geordie Member Posts: 655
    Hi, please check CheckNoOfRows function in Export Analysis View codeunit which performs this control.
    * Daniele Rebussi * | * Rebu NAV Diary *

Categories