View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Displaying pivot cell underlying data

The list that's created should only include the records summarized in
the cell that you double-clicked. Can you give an example of the results
that you're seeing?

watkincm wrote:
One of the really neat features of a pivot is that by clicking on a pivot
cell, it displays a new worksheet of the underlying data that makes up the
cell value.... Unfortunately, this is having unpredictable results - some
times many more rows are returned than the value in the pivot cell.
Can anyone tell me why this is - or am I doing something dumb...?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html