PDA

View Full Version : How to get the Last Refreshed date from a Workbook Query?



generalledger
2016-11-11, 05:02 PM
How can I pull the Last Refreshed date from a Workbook Query?

While in the Excel window, the Workbook Queries pane displays the name of the queries. If you hover your mouse over the name of a query it displays a lot of information about the query. One piece of information is the Last Refreshed date. Can we return this date to Excel? Is there an M function for this?