Microsoft Dynamics NAV (Archived)

Table 370 Excel Buffer Error

(0) Share

Report

Posted on by Jatin Patel

2,641

Hi,

I am using NAV 2013 R2 build 35800.

I got below error in Table 370 Excel Buffer in function CloseBook() at line:

XlWrkBkWriter.ValidateDocument;

See below error:

Microsoft Dynamics NAV

---------------------------

A call to Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.WorkbookWriter.ValidateDocument failed with this message: The spreadsheet is corrupted. The following error occurred: The attribute 'r' has invalid value '4194304'. The MaxInclusive constraint failed. The value must be less than or equal to 1048576..

---------------------------

*This post is locked for comments

All responses (4)

Answers (1)

Jatin Patel 2,641 on at

Like (0)

Report

RE: Table 370 Excel Buffer Error

Yes I can run same operation with other filter. But for specific filter I am getting error.
Verified answer

Daniele Rebussi 2,480 on at

Like (0)

Report

RE: Table 370 Excel Buffer Error

So I think it's due to some non-valid values are going to be exported in the Excel file, are you able to try the same operation with another set of data or writing just some of the cells in the workbook?
Jatin Patel 2,641 on at

Like (0)

Report

RE: Table 370 Excel Buffer Error

I am creating new file. I am running report which is exporting data to excel.
Suggested answer

Daniele Rebussi 2,480 on at

Like (0)

Report

RE: Table 370 Excel Buffer Error

Are you creating a new file or opening an existing one and updating it? If it's the second case, try to create a new document, copy the content of the broken file into this and work with the new one.