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