good morning all.

I would like to automatically update my pivot table whenever I make changes to the raw data. I have tried:

private sub worksheet_activate()
run "pivotmacro"
end sub

and

private sub worksheet_calculate()
sheets("pivot").pivottables("pivottable1").refreshtable
end sub

but neither works......help