Excel Line Limit when exporting from Nav

Business Central/NAV Technical Forum
1

Does anyone know if there is a line limit when exporting an analysis view from Nav to Excel. Although I am on Excel 2007 with over 1 million rows allowed, the Nav export is erroring stating that Excel is limited to 65000 rows.

I have exported the data manually and then setup a pivot table on 200,000 rows from this text and this works, so it not an excel issue.

Any help would be most appreciated

Andrew

2

Hi Andrew,

Check Codeunit 424

IF NoOfRows > 65000 THEN
ERROR(Text032,65000,AnalysisView.FIELDCAPTION(“Date Compression”),AnalysisView.TABLECAPTION);

Hope this helps

Albert

3

Thats great.

Thanks very much

Andrew

4

If you go to Tools - Options - Under Max. no. of XML records put in a higher number and it should work.