Thanks for both of your replies. From your recommendations I will push for an additional 2GB of RAM and more hard disk. The reason the server has low specs is...

Hi Steve,

I also posted the same question on the MSDN forums - I received a workaround that does the job.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=769313&SiteID=1

Hi, thanks for your response. I'm far from an MDX expert myself, but I'm not sure that the TopCount function can give me what I want. From my understanding, a DRILLTHROUGH...

Unfortunately this hasn't helped - the Excel 2003 response time is still the same. Has anyone else got calculated members working in Excel 2003?

Yes 2005 does have this option. I haven't been able to try it out yet on Excel 2003 but it sounds very promising. Thanks!

Sounds like a good idea if I can work out how to export to XML programmatically. I will give it a go in the next few days and let you...

Currently we run several Access databases for different parts of the business, so there is a sales database, a financial one, a stock orders one etc.. Several of these are...

I don't know much about servers - does their main performance advantage arise from having arrays of disks? The 40GB disk that is already in the workstation is IDE, and I would...