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) / Error openin excel fro...
Microsoft Dynamics AX (Archived)

Error openin excel from AX

(0) ShareShare
ReportReport
Posted on by Jorge Btc 115

Hello,

Has anyone seen this error?

5684.excel-error.PNG

I'm trying to opening an excel book that I exported from AX 2012 CU9, I want to obtain the accounting transaction list report of all 2017 but I'm getting this.

*This post is locked for comments

I have the same question (0)
  • Jorge Btc Profile Picture
    Jorge Btc 115 on at

    The message is this:

    "We have found a problem with the content of vsi oct 2017. Would you like we try to recover the most posible data? If you trust in the origin of this book, clic on YES"

    If I clic YES, I don't get anything.

  • Suggested answer
    BorisD Profile Picture
    BorisD 2,826 Moderator on at

    Hello Jorge,

    If you are using a local Ax client, on your computer open Excel, Select File > Options.

    Select Advanced, scroll down to the General section, and then clear the Ignore other applications that use Dynamic Data Exchange (DDE) check box in the General area.

    Select OK.

    If your using AX through published application like RDS, then same steps need to be performed but on the RDS server.

  • Jorge Btc Profile Picture
    Jorge Btc 115 on at

    Hi Boris,

    The check box you are mentioning is already clear.

    It is weird because I export data of some months like march, april, june, etc and I can save and open the Excel book without problem, but if I export december, october or all months I get the error when I open the file.

  • BorisD Profile Picture
    BorisD 2,826 Moderator on at

    Are other users able to export December, October or all months without the error? Or is everyone with access to this information unable to see this exported data?

    If others are able to see it ok and one person cant. you can try clearing the cache on the AX client.

    go to File>Tools>Options>Usage data tab>Jobs Tab>select all>click File>Delete Record. Then form selections tab>select all>Click File>Delete Record.

    Another thing you can try is deleting the .AUC files. These files are located on the machine where the client is run from.

    C:\Users\(User Name)\AppData\Local. You will see AX_GUI files with extension of .auc

    Note: this is only if others are able to pull this data and only you cant.

  • Jorge Btc Profile Picture
    Jorge Btc 115 on at

    Thank you Boris,

    I'm not the only user that get this error, it is the same to all users.

    I did what you say when I faced with this problem, I already deployed this report again but it is still happening.

    Any other suggestion?

  • BorisD Profile Picture
    BorisD 2,826 Moderator on at

    Can you give me some details on how you are exporting this report to Excel. For example are you sending it to an email as a Excel document? Are you saving to file as Excel? Are you batching the report?

  • Jorge Btc Profile Picture
    Jorge Btc 115 on at

    I'm executing the report in AX succesfully, after that I save the report as an Excel document in my computer, finally I'm trying to open the file and it is in this moment when I get the error.

    I'm not batching the report, I'm not sending the file by email.

  • BorisD Profile Picture
    BorisD 2,826 Moderator on at

    is this the report in GL>Reports>Grouping>Transaction list by date?

  • Jorge Btc Profile Picture
    Jorge Btc 115 on at

    Hi,

    No, the report is this GL-->Reports-->Transactions-->Accounting transactions list

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