| Denny Lee 2005-12-01, 8:23 pm |
| 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/SQLServ...0382/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.
>
> ********************
********************
*********
>
>
|