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