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

Notifications

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 R2 Ex...
Microsoft Dynamics AX (Archived)

Dynamics AX 2012 R2 Excel Add-Inn Error. The data in the workbook and the behaviour or of any add-ins may not be correct.

(0) ShareShare
ReportReport
Posted on by Muhammad Moin Mubeen 520

Hi Everyone,

We are using Dynamics AX 2012 R2 CU7, and most of the client users are getting this error message while opening or some time during mid of any work on their excel workbook.

An Error occured. The data in the workbook and the behaviour or of any add-ins may not be correct. Consider Contacting your system administrator about this problem.

Failed to load Microsoft Dynamics AX registered workbook.

Please let me know if someone has any solution.

Thanks in Advance.

Regards,

Muhammad Moin.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Umesh Pandit Profile Picture
    Umesh Pandit 9,315 User Group Leader on at

    Hi Moin,

    Please find the useful post!

    dynamics-ax.blogspot.in/.../microsoft-dynamics-ax-2012-excel-add-in.html

    Please update with your finding.

  • Community Member Profile Picture
    Community Member on at

    Hi Moin,

    I am also having same issue. Have you got any solution?

    Regards,

    Shafi. V

  • Community Member Profile Picture
    Community Member on at

    I have become a similar problem with an Excel workbook that loads data from four tables (regarding projects and timesheet data) as the size of the workbook has increased (now 25 MB).

    I would be very thankful, if anyone has found a solution they would share.

    Best regards

    Torben Bedsted

  • ColbyGallagher Profile Picture
    ColbyGallagher 3,666 on at

    I've run into this a bit working with the add-in and have found the following things help:

    1.) Don't save the workbook with native Excel filters on the table objects.  It will cause this error. 

    2.) Sometimes going into design mode (click the "Fields" button) and then out and saving before refresh will eliminate the issue. 

    3.) If you get a "metadata" error, you probably have to start over, re-build the workbook from scratch. 

    4.) Sometimes this error can just be ignored.  

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans