web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Table 370 Excel Buffer...
Microsoft Dynamics NAV (Archived)

Table 370 Excel Buffer Error

(0) ShareShare
ReportReport
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..

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

OK

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

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Daniele Rebussi Profile Picture
    Daniele Rebussi 2,480 on at

    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.

  • Jatin Patel Profile Picture
    Jatin Patel 2,641 on at

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

  • Verified answer
    Daniele Rebussi Profile Picture
    Daniele Rebussi 2,480 on at

    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 Profile Picture
    Jatin Patel 2,641 on at

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans