Drill Down in Excel 2002 OLAP and SQL 2000

[chertel]

I am useing MS Analysis Server 2000 for building the Cubes & to display the result I am using MS-Excel 2002. In the cube which I have made, I have given the enabled the Drill Through option and selected all fields to drill through in the cube. I am able to see the row level data in the data pane of that cube in Analysis Server when I am choosing the Drill Through option. But I am facing the problem in Excel for the same i.e. I am not getting the row level data. I get the error "Cannot show detail data for that section"

I used to be able to do this when the pivot was running off a table.

My question is, Is there any setting I have to do? What am I missing here. There has got to be a way to get this resolved.

Please help me out.

Thanks in advance.