can excel view drill throughs in a pivot table "Andy S." <andymcdba1[ at ]noreply.yahoo.com> 01.12.2005 16:24:35 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[ at ]noreply.yahoo.com Please remove "noreply" before replying. *************************************************

Re: can excel view drill throughs in a pivot table "Denny Lee" <dennyglee[ at ]hotmail.com> 01.12.2005 21:53:28 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/ "Andy S." <andymcdba1[ at ]noreply.yahoo.com> wrote in message news:%23WCO5Op9FHA.808[ at ]TK2MSFTNGP09.phx.gbl... [Quoted Text] > 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[ at ]noreply.yahoo.com > > Please remove "noreply" before replying. > > ************************************************* > >