web
You’re offline. This is a read only version of the page.
close
Skip to main content
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

I have the same question (0)
  • 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.

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 8,370 Super User 2025 Season 2 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
    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.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Saurav.Dhyani Profile Picture

Saurav.Dhyani 2 Super User 2025 Season 2

#2
RK-25090803-0 Profile Picture

RK-25090803-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans