PivotTable: RefreshTime vs. ChangedTime
 

Greetings All,

I am only interested in refreshing the pivottable when a change occurs in
the data source and upon activation of the sheet where the pivot table lies
in. I don't want to automatic reflect the changes to the pivottable, heres
is what my goal is:

I am stuck in putting together a code (in activate the sheet event) that
checks when was the last time the pivotable was refreshed and compares that
with the last time the source data was changed. I was able to do a timestamp
on the source if any changes where detected (called it 'changed').
What I need is to set up another Date variable in the activate sheet event
procedure (maybe a Static variable) to check if the 'Changed time' is newer
than 'Refresh' time then refresh.

I really appreciate your help on this important issue.

Thanks,
Sam