AuditorGirl Wrote:
update each time a
pivot table is opened....but how do I also include a "last date
refreshed"
Any data like this will need VBA, because you can't guarantee 'when'
the last day of access was. I assume you have set the Pivot table to
Auto refresh when opened. Hence all you need is the last date opened.
A simple VBA macro like this will do it.
Sub auto_open()
Sheets("sheet1").Range("A1").Value = Now()
End Sub
Matt
--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile:
http://www.excelforum.com/member.php...o&userid=35514
View this thread:
http://www.excelforum.com/showthread...hreadid=553787