65000 Rows when Export to Excel

manisharma31

I am receiving an error when posting an Invoice.
Error(Excel allows only 65000 rows,Compress the data filter)
Have any one receive this error before,what is the solution.

Tomas

manisharma31 wrote:

I am receiving an error when posting an Invoice.
Error(Excel allows only 65000 rows,Compress the data filter)
Have any one receive this error before,what is the solution.

Do you print anything to excel when posting invoice?
65000 is a limit of rows Excel (older than 2007) can hold in one sheet.

Luc_VanDyck

It is not standard NAV that lines are send to Excel, when posting invoices. So I guess you can safely say that nobody has seen this error before ;-)

You should contact your partner who has customized your database.

manisharma31

There is no Customization done in Nav by partner.
In Codeunit 424,Function Createfile ,there is this standard code written for Excess 65000 Rows in Excel.
You can find it in Nav 5 also.

Waldo

Ok ... but this codeunit isn't run when posting an invoice, is it?