Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Excel add-in fetching old data

Posted on by Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Excel add-in fetching old data

    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?

  • inadir Profile Picture
    inadir 400 on at
    RE: Excel add-in fetching old data

    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

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,113 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans