You're much more likely to get suggestions if you post your test code and
timings.

Tim


"moorey" wrote in message
...
Hi Guys,

My questions relate to pivot tables in excel 2003 that are extracting data
from OLAP.

Through testing i have found that there are major differences in execution
time by changing either the activesheet or the syntax from
pivotcache.refresh
to refreshtable. Yet on MSDN there is no explanation defining the
differences
between these 2 commands and why/whether sheet activation would have any
impact on the execution time.

I was wondering if someone could explain the underlying mechanics for each
of the 2 different lines of syntax and whether sheet activation could
impact
performance. Any help you can offer would be much appreciated.

Kind Regards
Moorey