Provide function to return "Last Refreshed Date" for external data connections
I don't want to have to click data->connections in Excel in order to see when a data connection was last refreshed. It would be great to provide function to return "Last Refreshed Date" for external data connections. It's a simple thing that would make a lot of people happy.
Agreed, not sure why such a simple yet helpful function was removed in the first place... Please bring it back for it makes our life a lot easier!
Yes, showing Last Refreshed Date is a basic function that should not have gone missing in the first place.
Loo Chin Lau (Heng) commented
For good user experience, i support the idea of showing 'Last Refreshed Date' timestamp for external data connections, if not, i would say it's not user-friendly at all!!
Su Wei commented
I agree - in earlier versions of Excel, there used to be a dialog box listing all the Workbook Connections AND its last refreshed dates without having to click on each Connection 1 by 1.
This is regressing to poorer user experience IMHO.
Dory Owen commented
Great suggestion. I even tried to get the Last Refreshed date from Workbook.Queries collection - even though I can see that date displayed in the Query preview. Nope. I need my users to know how fresh that data is.