web
You’re offline. This is a read only version of the page.
close
Skip to main content
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

I have the same question (0)
  • 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

  • Community Member Profile Picture
    Community Member 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?

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
AlissonGodoy Profile Picture

AlissonGodoy 2

#2
Community Member Profile Picture

Community Member 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans