Refresh Pivot Tables without refreshing functions

P

Peter D

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
 
R

Roger Govier

Hi Peter


Perhaps
Application.EnablEevents =False
your code
Application.EnableEvents=True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivottable refresh problem 1
Macro pt.RefreshTable 2
Efficiency in code 1
Code to Refresh inbound data sheets, then Refresh Pivot Tables 3
macro refinement 2
refresh multiple pivot tables in workbook 2
Pivot tables not refreshing after data source update 1
Refresh data with macro code 0

Top