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

I was using the function Export to Excel from the Config. Package Card in Microsoft Dynamics NAV 2017 when I’ve received the following error message:

A call to Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.WorkbookWriter.Create failed with this message:
Could not load file or assembly ‘DocumentFormat.OpenXml, Version=2.5.5631.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35’ or one of its dependencies. The system cannot find the file specified.

A call to Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.WorkbookWriter.Create failed with this message:
Could not load file or assembly 'DocumentFormat.OpenXml, Version=2.5.5631.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.

Cause:
Probably Open XML SDK 2.5 for Microsoft Office has not been installed on your computer.

Solution:
Close Excel.
Install Open XML SDK 2.5 for Microsoft Office from Microsoft Dynamics NAV DVD, the installation file is under

Prerequisite Components\Open XML SDK 2.5 for Microsoft Office\

Restart NAV Service after the installation.

Did my solution solve your problem? Leave a reply.

Exception from HRESULT 0x800AC472

Microsoft Dynamics NAV
—————————

Exception from HRESULT: 0x800AC472
—————————
OK
—————————

Exception from HRESULT 0x800AC472

Exception from HRESULT 0x800AC472

Solution:
Activate Microsoft Office Excel inserting the Product Key then close and reopen it.

Did my solution solve your problem? Leave a comment.

HOW TO Copy from Excel and Paste as Picture without gridlines

The title of this post contains exactly the words I used to search on Google.
Why for this simple task I’m writing a post?
Because in this case, as happens often, the task is easy but we should know the logic behind the software and functionalities we want use.
To clarify the concept: we want

"Paste as Picture hiding gridlines"

rather then

"Copy as Picture without gridlines"

HOW TO Copy from Excel and Paste as Picture without gridlines?

The correct tile of the this post should be

HOW TO Copy as Picture without gridlines from Excel

Click Copy -> Copy as Picture…

Copy as Picture

Under Appearance section, select “As shown when printed“, then click OK

Copy Picture As shown when printed

When you’ll paste it, for example in a Word document, the image will be without gridlines.

Did my HOW TO help you? Leave a reply.

The file {WordDocumentName} cannot be opened because there are problems with the contents

The file {WordDocumentName} cannot be opened because there are problems with the contents

The file {WordDocumentName} cannot be opened because there are problems with the contents

Solution:
Click OK in the error message.

Then will appear the following message and click Yes
Word found unreadable content in {WordDocumentName}

Save the file in RTF (Rich Text Format) file format then save it in Word Document format.

Reference: Troubleshooting damaged documents in Word for Windows

Did my solution solve your problem? Leave a reply.

The currently selected Visio driver is not compatible with the data source

—————————
Microsoft Visio
—————————
The currently selected Visio driver is not compatible with the data source.
—————————
OK
—————————

I created a new Data Source using the installed Microsoft SQL Server VISIO drivers: SQL Server Native Client 11.0 but when I try to use it appears the following error message:

The currently selected Visio driver is not compatible with the data source

The currently selected Visio driver is not compatible with the data source

Solution:
Use the Generic OLE DB Provider

Did my solution solve your problem? Leave a reply.

Microsoft Excel and Microsoft Word – Paste formatted text not work

Solution:

Just uninstall the Skype Click to Call plug-in.

Did my solution solve your problem? Leave a reply.