Thank you! I'm glad you like it.

lovemuch wrote:
BTW...I really like your website. I've been doing quite a bit of research
lately for budget spreadsheets for my employer. Most sites are very
unorganized with too much information and business. Your's is laid out in a
clear and very useful manner. Cynthia

"Debra Dalgleish" wrote:


No, you can't select a destination for the data that's created. Excel
adds a sheet, and places the data there.

lovemuch wrote:

I have a related question. Is there a way to have the underlying data go into
just one new worksheet when you double-click/drill-down on a cell? Right now
Excel adds a new worksheet for every cell you drill-down on. Thanks!
Cynthia

"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...?
--
Mike Watkins


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





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