software

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: www.excelforum.com/member.php...oamp;userid=30728
View this thread: www.excelforum.com/showthread...hreadid=540126I do it the way you do it--just delete that newly created sheet.

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

--

Dave Peterson