You could use something like this if you want the current date time i
cell A1 when the pivot table updates. Remember to format cell A1 wit
the date time format you want.
Code
-------------------
Sub Workbook_SheetPivotTableUpdate()
Range(A1).Value = NOW()
End Su
-------------------
chris46521 Wrote:
Thanks for your response! Do you know what code I might use to make tha
work? I am not that familiar with VBA. Thanks again
--
Excelenato
-----------------------------------------------------------------------
Excelenator's Profile:
http://www.excelforum.com/member.php...fo&userid=3676
View this thread:
http://www.excelforum.com/showthread.php?threadid=57224