Temporarily Disable/Cancel pivottable refresh
 

I'm adding cubefields through vba code and everytime a field is added, the
pivottable is refreshed. Well, I don't want this to happen all the time.

It doesn't seem like I can use pt.PivotCache.EnableRefresh = False because
then the pt.cubefields.orientation method fails. (I'd use the addfields
method to all mostly all of them at once, but I think that you can't if
working with an OLAP source)

msdn says PivotCache.BackgroundQuery is disabled for OLAP sources..
otherwise that might have worked.
http://msdn.microsoft.com/library/en...HV05199459.asp

Any ideas?
Thank you!!