"An error occurred. The data in the workbook and the behavior of any
add-ins may not be correct. Consider contacting your system
administrator about this problem.
Object reference not set to an instance of an object."
Check:
http://daxdilip.blogspot.in/2011/08/troubleshooting-dynamics-ax-2012-excel.html
Thanks & Regards,
Mail ID: pandit.umesh@hotmail.com
Skype ID: pandit.umesh