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) / A call to Microsoft.Dy...
Microsoft Dynamics NAV (Archived)

A call to Microsoft.Dynamics.Nav.OpenXml.Spreadsheet WorkbookWriter.Create failed with this message

(0) ShareShare
ReportReport
Posted on by sanjeet 2,205

Hi expert,

I am getting an error while generating excel from the report. Print to excel is working fine on my system.

when trying to generate excel this way it is working ok.

scenario-1.JPG

But after trying to write code to generate excel. I am getting an error. My code is something like this

excel-code.JPG

Getting Error Like this.

EXcel-Open-xml-error.JPG

I am using an Activated version of Excel 2016. Try to resolve my issue with the help of various link available but unable to resolve my issue.

I have done following thing.

1). To check about excel add-in Go to Excel -->  File --> Option --> Add-Ins --> COM add-ins --> Go --> select the Dynamics NAV excel add-in and click ok.

2.) Install the Pre-Requisite "Open XML SDK 2.5 for Microsoft Office" in the Pre-Requisite Folder of Product DVD

*This post is locked for comments

  • Suggested answer
    Andrey Baludin Profile Picture
    Andrey Baludin 3,941 on at
    RE: A call to Microsoft.Dynamics.Nav.OpenXml.Spreadsheet WorkbookWriter.Create failed with this message

    It's a bug:

    blogs.anandnavconsultant.com/.../microsoftdynamicsnavopenxml.html

    Install the last cumulative update of NAV2016.

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 6,690 on at
    RE: A call to Microsoft.Dynamics.Nav.OpenXml.Spreadsheet WorkbookWriter.Create failed with this message

    Seems to be a system specific Issue,
    Have you Installed all your Prerequisites of NAV.

    See office is properly installed.

    This is a standard NAV feature of all depends on installations office and  Prerequisites 

  • Suggested answer
    Erik Anders Profile Picture
    Erik Anders on at
    RE: A call to Microsoft.Dynamics.Nav.OpenXml.Spreadsheet WorkbookWriter.Create failed with this message

    Hello Sanjeet,

    try

    Excelbuf.CreatebookandOpen('','MP Seller Detailes',COMPANYNAME,'',USERID);

    instead of 

    Excelbuf.CreatebookandOpen('Seller Payment','MP Seller Detailes',COMPANYNAME,'',USERID);

    The Initialisation of Excelbuffer is sometimes wierd.

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans