It is better we install office 2010 add-ins for AX 2012. When i try to install it through Office 2007 SP2 but failed.
1, AX2012 clients reinstall
After the clients of AX2012 was uninstalled, i tried to reinstall it but failed and reported a error:
Setup encountered an unhandled exception and could not be completed. For details see the previous messages in the log
Then checked the log, It said "Object reference not set to an instance of an object" as below.
2012-04-06 10:51:32Z Message: Object reference not set to an instance of an object.
2012-04-06 10:51:32Z FullText: System.NullReferenceException: Object reference not set to an instance of an object.
2012-04-06 10:51:32Z at Microsoft.Dynamics.Setup.Components.ClientUI.GetCurrentClientConfigurationPath()
2012-04-06 10:51:32Z at Microsoft.Dynamics.Setup.Components.ClientUI.GetClientAosServerAndPortFromRegistry()
2012-04-06 10:51:32Z at Microsoft.Dynamics.Setup.S220ClientAosServerEntry.IsPageApplicable()
2012-04-06 10:51:32Z at Microsoft.Dynamics.Setup.MainForm.FindNextPage(PageID oldPageID)
2012-04-06 10:51:32Z at Microsoft.Dynamics.Setup.MainForm.mainFormButtonNext_Click(Object sender, EventArgs e)
2012-04-06 10:51:32Z at System.Windows.Forms.Control.OnClick(EventArgs e)
2012-04-06 10:51:32Z at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
2012-04-06 10:51:32Z at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
2012-04-06 10:51:32Z at System.Windows.Forms.Control.WndProc(Message& m)
2012-04-06 10:51:32Z at System.Windows.Forms.ButtonBase.WndProc(Message& m)
2012-04-06 10:51:32Z at System.Windows.Forms.Button.WndProc(Message& m)
2012-04-06 10:51:32Z at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
2012-04-06 10:51:32Z at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
It seems that the client can't find AOS instance but not sure. I tried many times and the issue still existed.
Then i try to install an AOS instance with the client (client, addins, remote), the process can be completed. At the end, the client was installed and it can access original AOS.
2, In Office 2010, office add-ins can be installed for AX2012 successfully.
Then open Excel2010, it has a tab named Dynamics AX on the head of Excel 2010.
Connection button: show which company and AOS information you log on; if you can't connect to the server, please check regedit:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\Excel\Addins\Microsoft.Dynamics.AX.Framework.OfficeAddin.Excel->Manifest's data change to
file:///C:/Program Files (x86)\Microsoft Dynamics AX\60\OfficeAddins\Microsoft.Dynamics.AX.Framework.OfficeAddin.Excel.vsto|vstolocal
Add data/Add table button, you can select AX2012 tables to Excel. If you select one table, it will drag a default group field Excel.
You can drag others tables which it has a flag similar as * to the right area.
Refresh Current button to display the table data in Excel from AX2012.