Since MS Excel 2007 has capability of taking 10L records but from NAV 2013 report viewer unable to transfer more than 65000 rows.
in Codeunit 424 function CheckNoOfRows, NAV checks whether excel version is >= 12 and number of rows is greater than 65000.
Check what is going wrong in that code..
Code written as below
IF ExcelVersion = '' THEN
IF NOT ISCLEAR(xlApp) THEN
ExcelVersion := COPYSTR(xlApp.Version,1,MAXSTRLEN(ExcelVersion));
IF (ExcelVersion < '12.0') AND (NoOfRows > 65000) THEN
I need to understand why such code is there if both are MS product and MS Excel 2007 support more than 10L rows. Is there any limitation isn NAV 2013 and what excatly done in NAV 2013 R/2 to resolve such issue.
Is any separate patch available to resolve this?
Thanks in advance..
The code is same in NAV2013R2 also.
Set debugger and check what is the value of ExcelVersion.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics