Hi, I am still stumbling with PQ so it is ok to laugh at the question
I click on Data > Refresh All to update a fairly large workbook. Today it appears that not all the queries refreshed. So I want to add a cell or column or something to the query to show me when it last refreshed. That way I can watch for it and if something is broken I at least have a start point. I did a generic google search and found a couple of VBA MACROS that I can make work. But, since I am studying PQ I would really be happy if the solution is something new to me in PQ. Any advice appreciated and thank you for taking time to read this question.
I click on Data > Refresh All to update a fairly large workbook. Today it appears that not all the queries refreshed. So I want to add a cell or column or something to the query to show me when it last refreshed. That way I can watch for it and if something is broken I at least have a start point. I did a generic google search and found a couple of VBA MACROS that I can make work. But, since I am studying PQ I would really be happy if the solution is something new to me in PQ. Any advice appreciated and thank you for taking time to read this question.