How to get the Last Refreshed date from a Workbook Query?

generalledger

New member
Joined
Oct 15, 2016
Messages
10
Reaction score
0
Points
0
Location
New Jersey, USA
Excel Version(s)
2016
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?
 
Back
Top