Refresh Pivot Tables without refreshing functions
 

I have a worksheet with five pivot tables which are refreshed from a macro as
follows -
For Each pt In ActiveSheet.PivotTables
pt.RefreshTable
Next pt
The worksheet also has a lot of custom functions. The problem is that the
functions also refresh when the code line "pt.RefreshTable" runs. Is there a
way to refresh the pivot tables without running the functions?
Thanks

Refresh Pivot Tables without refreshing functions
 

Hi Peter


Perhaps
Application.EnablEevents =False
your code
Application.EnableEvents=True
--
Regards
Roger Govier

"Peter D" <Peter wrote in message
...
I have a worksheet with five pivot tables which are refreshed from a macro
as
follows -
For Each pt In ActiveSheet.PivotTables
pt.RefreshTable
Next pt
The worksheet also has a lot of custom functions. The problem is that the
functions also refresh when the code line "pt.RefreshTable" runs. Is
there a
way to refresh the pivot tables without running the functions?
Thanks

Refresh Pivot Tables without refreshing functions
 

Wonderful,
Thanks Roger

"Roger Govier" wrote:

Hi Peter


Perhaps
Application.EnablEevents =False
your code
Application.EnableEvents=True
--
Regards
Roger Govier

"Peter D" <Peter wrote in message
...
I have a worksheet with five pivot tables which are refreshed from a macro
as
follows -
For Each pt In ActiveSheet.PivotTables
pt.RefreshTable
Next pt
The worksheet also has a lot of custom functions. The problem is that the
functions also refresh when the code line "pt.RefreshTable" runs. Is
there a
way to refresh the pivot tables without running the functions?
Thanks