Analysis By Dimension Report Error on Print to Excel

abhi1901

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

But we are having Ms Office 2007 and standard code is using automation Variable
And office 2007 can have up to 1000000 rows Then why this error is showing???

:roll:

Chinmoy

Find the exact source of the error by activating the debugger.

abhi1901

Thanks.

I have put the debugger actually There is a function in codeunit 424 (Export Analysis View) as CheckNoOfRows in that there is code as
If noofrows>65000 then
ERROR();

So can I can comment that code.???

ara3n

It's worth a try.

Chinmoy

I would rather suggest, that check the max number of rows supported by your version of Excel and put that number for validation.

Chn

abhi1901

Thanks.
I have increased 65000 to 1000000 as supported by Excel 2007.

manisharma31

Its a bug in the system.
Microsoft has not modified the code, as there are many users who now use excel 2007 & 2010.

It would be good to filter the analysis by dimension report before exporting it to excel.

manisharma31

The issue has been resolved in Dynamics NAV 2013 by MS.
The new code now checks the excel version.