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…

Comments

[waldo]

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...