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.

The Excel buffer already exist identification field and value Row No =2 Column No = 1" error why and how solve - NAV Developers Forum - Dynamics NAV Users - DUG

Excel Buffer

Microsoft Dynamics NAV
---------------------------
The Excel Buffer already exists. Identification fields and values: Row No.='2',Column No.='1'
---------------------------
OK

Solution :-
This error only occurs when you have written code to generate excel and it is over writing some rows in Excel Format.

So check your code

This error only occurs when you have written code to generate excel and it is over writing some rows in Excel Format. 

So check your code.

How to insert a new Logo in new company using MS Dynamics NAV?

Logo Implementation in NAV 2017

Requirement
New Logo to be inserted in Company Information Table.

Steps :-
We need to delete the Cronus Logo from Company Information Page. To do this Search Company Information in RTC Search Bar. 

Right Click on the by default Cronus Image & delete the picture. Again Right Click and Select Picture. New logo will ready to print in all Reports.