View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Excelenator[_47_] Excelenator[_47_] is offline
external usenet poster
 
Posts: 1
Default Date in cell to update upon Pivot Table refresh


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