S
Sam K
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
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