Re: $$Excel-Macros$$ Pivot uncheck All

2012-02-27 Thread NOORAIN ANSARI
Dear Deba, Please send your query in seprate mail instead of Thread mail. On Mon, Feb 27, 2012 at 4:21 PM, Deba Ranjan wrote: > *Hi Expert, > > Please create a automatic pivot table by help of marcos in urgent basis. > Please . > * > > > > > *Regards* > > *Deba Ranjan P** > * > *[image:

Re: $$Excel-Macros$$ Pivot uncheck All

2012-02-26 Thread dguillett1
: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Pivot uncheck All Hi All, Below is the Macro I have recorded for unchecking the Pivot Table. ActiveSheet.PivotTables("PivotTable2").PivotFields("Month").CurrentPage = "(All)" With ActiveSheet.PivotTab

Re: $$Excel-Macros$$ Pivot uncheck All

2012-02-26 Thread Kiran Kancharla
Thanks a lot. Will update you tomorrow on this.. Thanks, Kiran On Sun, Feb 26, 2012 at 11:57 PM, xlstime wrote: > you can use ActiveSheet.PivotTables("PivotTable1").ClearAllFilters > > > > > > At the top of the window, on the Ribbon, click the *Options* tab under > *PivotTable > Tools*. In th

Re: $$Excel-Macros$$ Pivot uncheck All

2012-02-26 Thread xlstime
you can use ActiveSheet.PivotTables("PivotTable1").ClearAllFilters or At the top of the window, on the Ribbon, click the *Options* tab under *PivotTable Tools*. In the *Actions* group, click *Clear*, and then click *Clear Filters *. Be sure you really want to do this before you undo all your se

$$Excel-Macros$$ Pivot uncheck All

2012-02-26 Thread Kiran Kancharla
Hi All, Below is the Macro I have recorded for unchecking the Pivot Table. ActiveSheet.PivotTables("PivotTable2").PivotFields("Month").CurrentPage = "(All)" With ActiveSheet.PivotTables("PivotTable2").PivotFields("Month") .PivotItems("Jan").Visible = False .PivotItems("Fe