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