Temporarily Disable/Cancel pivottable refresh

R

rab_wot

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!!
 

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

Top