Plataan - Microsoft Dynamics - Learning & Competence Management Vincent Bellefroid Koen Stox Steven Renders Conny Schuddinck Steffie Alexiou
A blog about Microsoft Dynamics
Home Archives Subscribe Plataan website

« Getting the text out of a Dialog (Error/Message) box in Dynamics NAV | Main | How to use Enterprise No in NAV 5.0 SP1 »


Max. no. of XML records to send ?

Recently I got this error when trying to use the Export to Excel button on the Customer list of a Dynamics NAV database:

This made me wonder: Is the export to Excel function limited to only 5000 records ?

Well, yes, it is, but the good news is that you can override this limit. When you go to Tools è Options there's a field called: "Max. no. of XML records to send" and its value is set by default to 5000.

So by increasing this you are able to send more than 5000 records towards Excel:

Of course, keep in mind that increasing this to a high value, you potentially can decrease system performance…


This is what I heard:
They intentionally put this by default to 5000, because OfficeXML tends to go much much much slower when exporting more then 5000 records. Nothing NAV can do about that...

The comments to this entry are closed.

October 2011

Mon Tue Wed Thu Fri Sat Sun
          1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30

Plataan Community

Visit us on LinkedIn Visit us on Facebook Visit us on Twitter