drill downs

[leonora]

there is a drill down in which the list includes about 100
items and on the list worksheet when I access the drill
down only 20 or so items appear in the list. how can I
make the whole list appear in the drill down ??

 

[Dave R.]

Forgive me if this is a common term in Excel or even computing in general,
but what is a drill down?

 

[Dave W]

perhaps the reference is to a pivot table worksheet

 

[Stephen Dunn]

The purpose of a drill-down is to show the data items that are used to
produce the value that you double-click on. If the full list was displayed
from drill-down, it would be pointless...