A/R and A/P Aged Reports_ print to excel error

tsv

Hi all,

I have installed Nav 2013 and MS office 2010.
when running the "Aged Accounts payable" report from NAV 2013 with print to Excel option the system throws the following error

"Cannot create an instance of microsoft.office.interop.excel,version=14.0.0.0,culture = neutral,publickkeytoken=71e9bce111e9429c, type Micorosft.Office.Interop.excel.ApplicationClass".

this eror occurs when the breakpoint hits at "PreOpenExcel" method of Excel Buffer table at the line
XlApp := XlApp.ApplicationClass;

can anyone help me on this.

geordie

Did you install Office properly also on the server where the service is running?
I suppose you get the same error with other reports, right?

Please check "XlApp" variable subtype, if the .NET Type List is empty something is missing...

tsv

Thanks for the reply.
the office is installed in the server running the service.
and getting this error in all the reports with the "Print to excel" option.

This is my subtype for the variable "XlApp"
Microsoft.Office.Interop.Excel.ApplicationClass.'Microsoft.Office.Interop.Excel, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'

Am i missing something?

tsv

i even replaced the Addins folder in the path "C:\Program Files (x86)\Microsoft Dynamics NAV\70\RoleTailored Client\Add-ins" with the folder in the installation setup files "NAV DVD\RoleTailoredClient\program files\Microsoft Dynamics NAV\70\RoleTailored Client\Add-ins"

but no luck

geordie

tsv wrote:

i even replaced the Addins folder in the path "C:\Program Files (x86)\Microsoft Dynamics NAV\70\RoleTailored Client\Add-ins" with the folder in the installation setup files "NAV DVD\RoleTailoredClient\program files\Microsoft Dynamics NAV\70\RoleTailored Client\Add-ins"

but no luck

In Add-ins directory (of the server running the service) do you have "Microsoft.Dynamics.NAV.Integration.Office.dll" file? Which version is it?

If you can access via RDP to that server I suggest also to run Excel from Windows in order to verify if the installation has been done properly.

tsv

The version is 7.0.33781.0.
i have attached the property sheet for the "Microsoft.Dynamics.NAV.Integration.Office.dll"
i didn't understand about running the Excel from Windows? is it from "Start -> All programs" you mean

geordie

tsv wrote:

i didn't understand about running the Excel from Windows? is it from "Start -> All programs" you mean

I just wanted to ask you running as a "normal" Windows to check possible error in Excel startup...

I don't have many clues left: a silly question, the NAV service user has the right permission to access to Excel installation directory, isn't it?