Export Pivot Table from Webparts to Excel

[Glenn_lim]

Hi!

I have a question here regarding exporting Pivot table from webparts in
sharepoint to excel. My pivot table is taking the data from OLAP Cube. And
when i try to export to excel, it will takes up to 20mins (always showing the
"running OLAP query" msg in excel). Any way to speed up the process or trace
wheres the problem?
Another problem i encounter is that even thou my columns are minimised, upon
export to excel, all the columns and data will be shown. But the previous
reports which my colleague done doesn't have this problem. What we see in the
webpart is what we exported.

Using Analysis Services 2000, Windows Server 2003, Excel 2003, Microsoft
Office PivotTable 11.0, sharepoint services 2000

Thanks!

 

[Alvin Bruney [MVP]]

Seems like you have connection issues. Put a packet sniffer or have your
network guys/women, trouble-shoot the connection between the client and
cube.