Rapid Start Import Error

Business Central/NAV Technical Forum
1

Hello,

I get this error when trying to use the Export to Excel function in Rapid Start.

A call to Microsoft.Dynamics.Nav.Integration.Office.Excel.ExcelHelper.CallOpen failed with this message:
Unable to cast COM object of type ‘Microsoft.Office.Interop.Excel.ApplicationClass’ to interface type ‘Microsoft.Office.Interop.Excel._Application’.
This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{000208D5-0000-0000-C000-000000000046}’ failed due to the following error:
Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).

pastedimage1519592007638v1.png
pastedimage1519592007638v1.png769×546 33.4 KB

Any ideas?

UPDATE :
Dynamics 2018 - > Windows Server 2012(64bit) → Excel 2016 (32 bit). It’s a freshly installed Chronus.

2

Hi Thomas,
More details please. NAV version, client, OS, same for Excel. And does it happen on other PC’s and/with other user id’s?
Any other problems with Excel integration?

3

Hello,

Dynamics 2018 - > Windows Server 2012(64bit) → Excel 2016 (32 bit). It’s a freshly installed Chronus.

best regards,

4

And again: Does it happen on other PC’s and/with other user id’s?
Any other problems with Excel integration?

5

Hello,
sorry. Was not specific enough.
I just installed Chronus test Database. I’m using the client directly on the server.
There are no other users.

best regards,
Thomas Barbut

6

Ok, but do you have any other problems with the Excel or office integration in other parts of NAV? Or only when exporting questionaries?

7

Only when exporting the questionaries.

8

Do you have installed the neccessary Components in ADD-ins folders for DynamicsNAV90?

9

Hi Thomas,

I don’t know if this is the same case, this error can ocurr if there isn’t installed Excel in the computer, or the user have no permissions to use Excel. In my case, a client had installed LibreOffice and got this error.

The error apears in, exactly, the moment when tries to open excel (Function CallOpen)… You can change code to download file instead to try to open it.

This is a function I added to Excel Buffer to do that (NAV 2013R2):

DownloadExcel()
ClientFilename := 'Book1' + ExcelFileExtensionTok;

IF FileManagement.CanRunDotNetOnClient THEN BEGIN
  ClientFilename := FileManagement.SaveFileDialog('Save file','',Text034);
  IF ClientFilename = '' THEN
    EXIT;
  IF FileManagement.GetExtension(ClientFilename) = '' THEN
    ClientFilename += ExcelFileExtensionTok;
END;

FileManagement.DownloadToFile(FileNameServer,ClientFilename);
10

And you have tested other Excel exports?

The reason I ask, is that this kind of error typically is related to a somehow faulty installation, often related to Excel.
Checking that the other Excel exports, like exporting Rapid starts data export, works would show that that issue is not the installation.

11

Seems to be a Standard Error with some missing dll’s. I will recommend try reinstalling once with all prerequisites installed.

12

Hi Thomas,
Did any of the suggestions help you, or do you still have this problem?