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
|