View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Expand/Collapse in Pivot Tables

Sure! See my example he
http://www.mediafire.com/?4zzztyzjdjg

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"yowzers" wrote:

Is there any way to put in a button to expand and/or collapse groups of
grouped items in pivot tables? I know in regular spread sheets, there are
buttons on the left hand side of the sheet called 1, 2, 3, etc. which will
expand/collapse the entire level 1, 2, 3 groups of items. Looking for
something similar in pivot tables.