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.

Package Microsoft SQL Server 2005 Express failed with error. See detailed message above.

Package Microsoft SQL Server 2005 Express failed with error. See detailed message above.

The above error message appears when you try to install Microsoft Navision 6 Client on Windows Vista or Windows 7 or Windows 8.

Package Microsoft SQL Server 2005 Express failed with error

Solution:

  1. To copy the contents of DVD to your computer’s hard drive
  2. To explore the content to find \\Prerequisite Components\\Microsoft SQL Server 2005 Express folder
  3. Right-click on the SQLEXPR.EXE file Property -> Compatibility and set the Compatibility Mode to the previous O.S. version
  4. I suggest you to set the Compatibility Mode also for the Autorun.exe file in the main folder.

Did my solution solve your problem? Leave a reply.