There are more than 65000 rows within the filters.

manisharma31

Hi,
I am getting this error on classic client Nav 2009 SP1,when i am using the Financial Managment > General Ledger > Analysis & Reporting > Analysis by Dimensions > Function > Export to Excel.

"There are more than 65000 rows within the filters. Excel only allows up to 65000 rows.You can either narrow the filters or choose a higher Date Compression value on the Analysis View"

I am having Excel 2007 with 1048576 rows,still i get this error.
65000 Rows was the limitation for Office XP.

I have debug this error & in Codeunit 424 Export Analysis View,this function CheckNoOfRows is execuited.
If i change the CheckNoOfRows from 65000 to 1048576 then its working fine.

Is it correct to make the code change or to report this as a BUG.

einsTeIn.NET

I think it's an old check regarding to Excel 2003. Excel 2007 doesn't have this limitation.

manisharma31

yea,its kinda old.
But this kind of old things must have been taken care of when there is a version upgrade or is there any reason to keep this.
Lets see..

einsTeIn.NET

Even if you use NAV 2009 there is no need to use Excel 2007. Thus it could still be necessary to check it.

manisharma31

could be.
But i have commented the check code,as we have large gl entries for analysis purpose.

any how thanks dear.

kriki

[Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]