You can use programming to show the date of the last refresh.

On a regular module, add the following function:

Function PTRefresh(rng As Range) As Date
PTRefresh = rng.PivotTable.RefreshDate
End Function

On the worksheet, use a formula to display the date, e.g.:

="Last refreshed " & TEXT(ptrefresh(A4),"dd-mmm-yy hh:mm")

where A4 is a cell in the pivot table.

AuditorGirl wrote:
I need to create a header that includes a date that will update each time a
pivot table is opened--which I know how to do-- but how do I also include a
"last date refreshed"

In other words, when I first open this pivot table, I want to see
yesterday's date (last date opened) and today's date. Of course, sometimes I
will be opening it on Monday, and the last date opened will be the previous
Friday. Any help??

Thanks,





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html