mibuso.com

Microsoft Business Solutions online community
It is currently Tue Sep 02, 2014 8:51 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Excel only allows upto 65000 rows error resolved in NAV 2013
PostPosted: Wed Jun 06, 2012 9:52 am 
Offline

Joined: Mon Oct 06, 2008 2:05 pm
Posts: 267
Country: India (in)
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.


Top
 Profile E-mail WWW  
 
 Post subject: Re: Excel only allows upto 65000 rows error resolved in NAV
PostPosted: Thu Jan 02, 2014 12:28 pm 
Offline

Joined: Thu Jan 02, 2014 12:21 pm
Posts: 1
Country: India (in)
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.


Top
 Profile E-mail  
 
 Post subject: Re: Excel only allows upto 65000 rows error resolved in NAV
PostPosted: Thu Jan 02, 2014 2:00 pm 
Offline

Joined: Thu Oct 21, 2010 4:59 pm
Posts: 552
Location: Munich
Country: Germany (de)
Hi, please check CheckNoOfRows function in Export Analysis View codeunit which performs this control.

_________________
* Daniele Rebussi * | * Rebu NAV Diary *


Top
 Profile E-mail WWW  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: