you could use the "Workbook_SheetPivotTableUpdate" or th
"Worksheet_PivotTableUpdate" event to place the current date in
particular cell each time the pivot table updates
--
Excelenato
-----------------------------------------------------------------------
Excelenator's Profile:
http://www.excelforum.com/member.php...fo&userid=3676
View this thread:
http://www.excelforum.com/showthread.php?threadid=57224