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.
>
> *************************************************
>
>