can excel view drill throughs in a pivot table

I'm building pivot tables in Excel 2000 based on data cubes from SQL 2000
Analysis Services. Is there anyway to view the drill down from the data
fields in a Excel pivot table? I try doubleclicking in a data field cell
and get a message saying that I can only get detail from rows or columns.

*************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.noreply.yahoo.com
Please remove "noreply" before replying.
*************************************************
Oh, the message you are receiving is because you are clicking on a cell and
Excel does not have native drillthrough capabilities. A good example of
modifying Excel (via VBA) to have drillthrough capabilities can be found at:
http://www.windowsitpro.com/SQLServe...382/40382.html
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>
Blog at:: http://spaces.msn.com/members/denster/
"Andy S." <andymcdba1@.noreply.yahoo.com> wrote in message
news:%23WCO5Op9FHA.808@.TK2MSFTNGP09.phx.gbl...
> I'm building pivot tables in Excel 2000 based on data cubes from SQL 2000
> Analysis Services. Is there anyway to view the drill down from the data
> fields in a Excel pivot table? I try doubleclicking in a data field cell
> and get a message saying that I can only get detail from rows or columns.
>
> --
> *************************************************
> Andy S.
> MCSE NT/2000, MCDBA SQL 7/2000
> andymcdba1@.noreply.yahoo.com
> Please remove "noreply" before replying.
> *************************************************
>