Re: $$Excel-Macros$$ Using VBA to switch between calculated fields

2011-10-06 Thread Clint
Hi Ashish, Sorry I can't share the document. On Sep 21, 11:36 pm, ashish koul wrote: > Hi Clint > > Can you attach the sample file > > > > > > > > > > On Wed, Sep 21, 2011 at 11:08 PM, Clint wrote: > > This one has been driving me crazy. VBA seems to have a problem > > removing calculated fiel

Re: $$Excel-Macros$$ Using VBA to switch between calculated fields

2011-09-21 Thread ashish koul
Hi Clint Can you attach the sample file On Wed, Sep 21, 2011 at 11:08 PM, Clint wrote: > This one has been driving me crazy. VBA seems to have a problem > removing calculated fields. See code below. > > > Sub Value_Click() > >'' >Application.ScreenUpdating = False >Application.Calc

$$Excel-Macros$$ Using VBA to switch between calculated fields

2011-09-21 Thread Clint
This one has been driving me crazy. VBA seems to have a problem removing calculated fields. See code below. Sub Value_Click() '' Application.ScreenUpdating = False Application.Calculation = xlManual ' Dim PF As PivotField Dim pfNew As PivotField Dim Field As String