Problem Excel as OLAP Client with large volume of data

Dear all,

I am using Excel 2000 as my OLAP cube cleint. It's flexible and user friendly when I need to retrive data from cube. However, I am having problem when I need to retrive large volume of data from cube to the excel report (i.e: bank & finance report).

I tried link server but it doesn't make much different.

Can anyone tell me how to solve the problem, if I could only use excel or other license free application as my OLAP Client.

Thanks!

regards,
SamYou didn't mentioned about the problem you're having i.e., Performance related or query based.

If its performance based what is the current configuration of server and database information.