| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 -- anandmr65 ------------------------------------------------------------------------ anandmr65's Profile: http://www.excelforum.com/member.php...o&userid=30728 View this thread: http://www.excelforum.com/showthread...hreadid=540126 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table details
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
| pivot table created from another pivot table | Excel Worksheet Functions | |||
| Change Data In Pivot Table | New Users to Excel | |||
| how to delete/clean out the row list in pivot table | Excel Worksheet Functions | |||
Hybrid Mode
