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) / Excel add-in fetching ...
Microsoft Dynamics AX (Archived)

Excel add-in fetching old data

(0) ShareShare
ReportReport
Posted on by Community Member

The dynamics AX add-in is set to auto refresh when the workbook is open.  It does refresh when it opens, but the info that is returned is not current/correct.  It is almost like it is running against cached data.  after opening the file, if you go to the dynamics tab, and choose refresh, the data that is returned (running against the exact same queries that it ran against when it opened) is correct.

also have tried using the application.sendkeys function to get the tables to refresh.  Neither works.

How can I get these tables to update correctly without user intervention?

*This post is locked for comments

  • inadir Profile Picture
    inadir 400 on at

    Hi,

    be sure in your Excel that the setup connection is correct , sometimes , your Excel is set up with TEST environnement and you have to switch it always to PROD after opening file.

    Thanks

  • Community Member Profile Picture
    Community Member on at

    It is set to point to the same PROD environment on open that it is when the SAME query is executed via manual refresh.  The data that is in the tab after the update that executes upon opening of the file does not return the correct data.  Click on the manual refresh, and the data that is returned is the correct info.  How can the SAME query when ran on open return one result and the manual refresh return another?

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans