can excel view drill throughs in a pivot table

[Andy S.]

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
(e-mail address removed)

Please remove "noreply" before replying.

*************************************************

 

[Denny Lee]

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/SQLServer/Article/ArticleID/40382/40382.html

--
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>

Blog at:: http://spaces.msn.com/members/denster/