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

Change report firlds in pivot tables and charts with one selection 0
Macro Question. Is refresh needed? 0
Pivottable refresh problem 2
Efficiency in code 1
Macro pt.RefreshTable 2
Pivot tables - refresh. 0
Code to Refresh inbound data sheets, then Refresh Pivot Tables 3
VBA: Pivot Cache Help 1

Top