Tuesday, February 7, 2017

A call to Microsoft.Dynamics.Nav.OpenXML. Spreadsheet.WorkbookWriter.create failed MS Dynamics NAV

How to import Data using Excel Buffer in Navision?


Error Message :-

Microsoft Dynamics NAV
---------------------------
A call to Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.WorkbookWriter.Create failed with this message: The document type is invalid. Verify the file extension.
---------------------------
OK


Solution :-

This error occurs when you are working on NAV 2016 and trying to use Excel Buffer to create a Excel report in MS Dynamics NAV.

You can get details of this Update from here.
https://support.microsoft.com/en-us/help/3216191/cumulative-update-15-for-microsoft-dynamics-nav-2016-build-47671

You can download this update from here by entering the Microdoft Login Credentials.
https://mbs.microsoft.com/partnersource/global/search/Pages/results.aspx?k=CU15%2047838
Please follow all the mandatory info before implementing this update.
and enjoy Excel Buffer Functionality.
You can check your NAV installation by running the report 6 Trial Balance and Checking the Export to excel functionaltiy.