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

tsv
tsv Member Posts: 49
edited 2013-06-14 in NAV Three Tier
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.
with regards,
tsv

Comments

  • geordie
    geordie Member Posts: 655
    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...
    * Daniele Rebussi * | * Rebu NAV Diary *
  • tsv
    tsv Member Posts: 49
    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?
    with regards,
    tsv
  • tsv
    tsv Member Posts: 49
    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 :(
    with regards,
    tsv
  • geordie
    geordie Member Posts: 655
    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.
    * Daniele Rebussi * | * Rebu NAV Diary *
  • tsv
    tsv Member Posts: 49
    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
    with regards,
    tsv
  • geordie
    geordie Member Posts: 655
    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?
    * Daniele Rebussi * | * Rebu NAV Diary *

Categories