View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Ryan@newsgroups.nospam is offline
external usenet poster
 
Posts: 18
Default How do you get a pivot table to do server-side processing?

More specifically, I have noticed that connecting to an OLAP cube when it
gets complex enough Excel on the client uses 100% CPU. I thought that all of
the OLAP would be processed on the server.

The status bar reads Running OLAP query...

" wrote:

Is there a way to get excel to do server-side processing for a pivot table?

Ryan