Thread: Display time of last refresh of a Query?

VBA solution:

Sub RefreshAll()
'
' RefreshAll Macro
'

'
Application.ScreenUpdating = False
Application.StatusBar = "Refreshing......."
   ActiveWorkbook.RefreshAll
    With Range("a1")
     .NumberFormat = "mm/dd/yyyy h:mm:ss AM/PM"
     .Value = Now()
    End With
Application.StatusBar = "Ready"
Application.ScreenUpdating = True
End Sub

Steps:
1. Alt-F11 to display VBA editor
2. Right-click -> Insert -> Module
3. Copy/paste code
4. Will have to save-as macro enabled workbook if not already
5. Timestamp will appear in cell A1, so you need to change this if you want it somewhere else
6. You can assign to a button or run macro manually

Thanks for the help!