web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Dynamics AX 2012: erro...
Microsoft Dynamics AX (Archived)

Dynamics AX 2012: error "Object reference not set to an instance of an object" with Excel AddIn

(0) ShareShare
ReportReport
Posted on by Community Member

We have an installation of AX 2012 beta with every tier on its own machine. When Excel is called on the client-machine and we click on "Connection" we get a popup with the error message "Object reference not set to an instance of an object". When we do the same on the application server machine it works. The office add ins are installed on both machines.

*This post is locked for comments

I have the same question (0)
  • 640579632b5c4e6780a624c4771b6f93 Profile Picture
    640579632b5c4e6780a... 4,730 on at

    Go to File- >Option -> General - Miscellaneous

    under export to microsoft excel

    change the remote desktop seesion export to setting.

  • Community Member Profile Picture
    Community Member on at

    Hello Huzaifa,

    thanks for your reply!

    I think you mean File->Tools->Options->General->Miscellaneous->Export to Microsoft Excel->Remote Desktop Session exports to!? I've changed the setting here from "Client Excel" to "Server Excel". With no effect unfortunately. Excel is still started on the client machine, independently if I log on via rdp to the client machine and call AX there or if I call it from the browser via Remote Desktop Services/RemoteApp programs. Consequently the link between AX and Excel doesn't work still and I get the errormessage described in my initial posting.

    Regards

    Patrick

  • 640579632b5c4e6780a624c4771b6f93 Profile Picture
    640579632b5c4e6780a... 4,730 on at

    Attach visual studio debugger to the excel process and try to reproduce the error. Enable the clr exception. Stack Trace can give us information why it is happening

  • Community Member Profile Picture
    Community Member on at

    Now I've managed at last to install VS on the machine concerned and to get the debugger working. Result:

    1) "Details"-window

    System.NullReferenceException occurred
     Message=Object reference not set to an instance of an object.
      Source=Microsoft.Dynamics.AX.Framework.OfficeAddin.Excel StackTrace:      at Microsoft.Dynamics.AX.Framework.OfficeAddin.Excel.Application.GetActiveOrNewWorkbook()

     InnerException:

     

    2) (Complete) stacktrace

    Microsoft.Dynamics.AX.Framework.OfficeAddin.Excel.DLL!Microsoft.Dynamics.AX.Framework.OfficeAddin.Excel.Application.GetActiveOrNewWorkbook() + 0x33 bytes 

    Microsoft.Dynamics.AX.Framework.OfficeAddin.Excel.DLL!Microsoft.Dynamics.AX.Framework.OfficeAddin.Excel.ExcelDialogWindowController.ShowConnectDialog() + 0xb bytes

    Microsoft.Dynamics.AX.Framework.OfficeAddin.Excel.DLL!Microsoft.Dynamics.AX.Framework.OfficeAddin.Excel.ExcelRibbonController.Connect() + 0x6 bytes

      Microsoft.Dynamics.AX.Framework.OfficeAddin.Controls.DLL!Microsoft.Dynamics.AX.Framework.OfficeAddin.Controls.CustomRibbon.ButtonConnectClicked(Microsoft.Office.Core.IRibbonControl control) + 0x2b bytes
    [Native to Managed Transition]
    [Native to Managed Transition]
    [Appdomain Transition]

     I hope that helps...

     

    Regards

    Patrick

  • Community Member Profile Picture
    Community Member on at

    Hi there,

    I'm getting the same error when I try to launch the Dynamics AX > Connection via Excel Add-in. Any idea how to troubleshoot this one? This is a single computer install wherein I have loaded all the components on the same box and this is the first time I'm trying to bring up the Add-in. Any special configuration needs to be done to make this work?

    Cheers,

    Dilip

  • 640579632b5c4e6780a624c4771b6f93 Profile Picture
    640579632b5c4e6780a... 4,730 on at

    Can u uninstall the office service pack and reinstall the service pack from AX setup folder

  • 640579632b5c4e6780a624c4771b6f93 Profile Picture
    640579632b5c4e6780a... 4,730 on at

    Before uninstalling try this

    Can you please try going to the connection tab of the client configuration utility and pressing the "Refresh Configuration" button on a client that does not work?

  • Community Member Profile Picture
    Community Member on at

    Hello Huzifa,

    do you mean the AX office addins? For office we haven't installed a service pack. We have installed Office 2010 32-bit, the OS is WIndows Server 2008 R2 Standard SP1 64-bit.

    Regards

    Patrick

  • Community Member Profile Picture
    Community Member on at

    I've copied the Original configuration to be able to press the "Refresh" button. Then I have pressed the "Refresh" button, the poup saying that the WCF confugration is regenerated appeared. When it dissapeared I closed the configuration utility. The errormessage does still appear however.

  • 640579632b5c4e6780a624c4771b6f93 Profile Picture
    640579632b5c4e6780a... 4,730 on at

    I think installing service pack for office will resolve the problem

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 24

#2
Michel ROY Profile Picture

Michel ROY 14

#3
Jagadabi Profile Picture

Jagadabi 6

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans