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