Hi All,

I am facing a problem while using OLAP Cube in excel sheet. I am using SQL
Server 2000 and Service Pack 4.

When I put 3 - 4 dimensions on left side (left blue line area of pivot table),
this give me error message 'unexpected error occure' and some times, values
of measures (used for the purpose) go away.

Due to this unexpected error, i m not able to design any complex report and i
cant use more than 3 dimensions in the same report.

Anyone, who can help me, is requested to mail me at sanjeev.sharma.darc (AT) gmail (DOT)
com directly or reply this message.

Thanx

Saneev Kumar

Could be the version of MDAC/PTS on the client.

Try running the PTSFull.exe that should have come as part of SP4 on the
client computer. This will install the latest MDAC/PTS components on the
client.

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell