Pivot table details

Hi,
When a item is clicked on the pivot table, it opens a new sheet and gives the complete details of the individual item clicked. Once the details are viewed the new sheet remains. Is there any way to bring the view to normal and remove the new sheet or we should always physically delete the sheet. I have been deleteing the new sheet once the details are viewed, Please let me know if there is any other method.

Thanks in advance for your assistance.

Regards
Anand

I do it the way you do it--just delete that newly created sheet.

anandmr65 wrote:
>
> Hi,
> When a item is clicked on the pivot table, it opens a new sheet and
> gives the complete details of the individual item clicked. Once the
> details are viewed the new sheet remains. Is there any way to bring the
> view to normal and remove the new sheet or we should always physically
> delete the sheet. I have been deleteing the new sheet once the details
> are viewed, Please let me know if there is any other method.
>
> Thanks in advance for your assistance.
>
> Regards
> Anand
>
> --
> anandmr65
> ------------------------------------------------------------------------
> anandmr65's Profile: http://www.excelforum.com/member.php...o&userid=30728
> View this thread: http://www.excelforum.com/showthread...hreadid=540126

--

Dave Peterson