Runtime error -2147467259(80004005)

Hi all,
I am facing one problem in Excel Pivot Table. This is
happening while i try to drillthrough the data in excel
which is connected to a Database in Analysis manager. The
code is written in Excel as suggested in MSDN
(http://www.msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnexcl2k2/html/odc_xlextendolap.asp)
Most of the time i am getting the results ... some times
i am getting a runtime error as given below
"Runtime error -2147467259(80004005). The operation
requested failed due to Time out. "
This is happening while trying to open the recordset
(Rs.open).
Thanks in advance for any help regarding this...
Thanks & Regards
Sajith SIt's difficult to tell where the problem is based on just the description.
It may be a legitimate timeout based on the amount of data being returned
within whatever timeout period the client has set or defaulted to. Or it
could be the result of another problem such as:
301334 PRB: Connection Timeout Occurs When Connecting to a Remote OLAP
Server
http://support.microsoft.com/?id=301334
294664 FIX: Timeout Error While Browsing Data from Analysis Manager
http://support.microsoft.com/?id=294664
823357 PRB: Connection to Analysis Services Fails After You Install Analysis
http://support.microsoft.com/?id=823357
Check the event logs on the client and server to see if there any
additional clues there.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.