Issue in Excel Buffer

navuser1

Dear Sir,

The following issue is occurred while users are trying to export data using Excel Buffer Table.

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: Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)).

But it's working fine in the NAV tier (system).

How to solve it.
Kindly reply.

NavNab

All users or some users ?

If "some users", have you tried to do a quick repair of Office in their machines ?

Slawek_Guzek

Do you have Office / Excel installed on the user PC? Does it have the same bintess as the OS/ NAV client? (ie mixed 32bit Office on 64bit OS)

navuser1

NavNab wrote: »

All users or some users ?

If "some users", have you tried to do a quick repair of Office in their machines ?

All users are facing the same, but when I do the same in NAV Server, it's working fine.

I have repaired the MS Office several times, but it does not solve my issue.

navuser1

Slawek_Guzek wrote: »

Do you have Office / Excel installed on the user PC? Does it have the same bintess as the OS/ NAV client? (ie mixed 32bit Office on 64bit OS)

All are same version.

Slawek_Guzek

try this

navuser1

Thanks for your replies.....

I have noticed that the file is generated on the client PC silently but not able to open the same............

navuser1

(Client) Systems is stuck in the below line of Excel Buffer Table.

XlWrkBk := XlHelper.CallOpen(XlApp,FileNameClient);

Yury

navuser1 wrote: »

Thanks for your replies.....
I have noticed that the file is generated on the client PC silently but not able to open the same............

It means, that you can find generated file in temporary folder of ther users PC, can you?

navuser1

Yury wrote: »

navuser1 wrote: »

Thanks for your replies.....
I have noticed that the file is generated on the client PC silently but not able to open the same............

It means, that you can find generated file in temporary folder of ther users PC, can you?

Yes

Yury

Can you open it on the client machine directly from File Explorer?

navuser1

Yury wrote: »

Can you open it on the client machine directly from File Explorer?

Yes, users are able to open

Yury

Is it possible to compile Excel-related objects in user machine environment? As Slawek already said, it's probably different versions of libraries.

navuser1

Yury wrote: »

Is it possible to compile Excel-related objects in user machine environment? As Slawek already said, it's probably different versions of libraries.

Client has no developer Environment installed. BTW, client does not able to compile the Excel Buffer Table because client has few/one missing library..

Alex_Chow

The problem is if the machine has a newer version of Office and has been downgraded. NAV will call the latest version of the Office components since downgrading will not remove any of the settings in the reg keys.

You will need to go to regedit.exe and remove any keys related to office:
HKEY_CLASSES_ROOT\TypeLib\