Date of last refresh?

[Guest]

Is there a function that will return the date of the last refresh?

I have a spreadsheet that with many users. It would be helpful if the user
could tell when the last refresh occured to know whether they need to refresh
the data before using it.

 

[Guest]

Hi,

By refresh you mean? Pivot Table refresh, or spreadsheet recalculation or
the spreadsheet has changed or the spreadsheet has been saved?

In either case you can run a VBA macro to do this.

Private Sub Workbook_SheetCalculate(ByVal Sh As Object)
Sheets(1).Range("A1")= Now
End Sub

Private Sub Workbook_SheetPivotTableUpdate(ByVal Sh As Object, ByVal Target
As PivotTable)
Sheets(1).Range("A1")= Now
End Sub

Private Sub Workbook_Open()
Sheets(1).Range("A1")= Now
End Sub

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Sheets(1).Range("A1")= Now
End Sub

Cheers,
Shane Devenshire