Re: $$Excel-Macros$$ On time Issue

Thanks for your replies On Mon, Aug 11, 2014 at 8:11 PM, Vaibhav Joshi wrote: > see this att for ref. > > Cheers!! > > > On Mon, Aug 11, 2014 at 8:09 PM, Vaibhav Joshi wrote: > >> Hi >> >> In first code add at the end this line.. >> >> Call Ontime_PivotRefresh >> >> >> Cheers!! >> >> >> On Mon

Re: $$Excel-Macros$$ On time Issue

see this att for ref. Cheers!! On Mon, Aug 11, 2014 at 8:09 PM, Vaibhav Joshi wrote: > Hi > > In first code add at the end this line.. > > Call Ontime_PivotRefresh > > > Cheers!! > > > On Mon, Aug 11, 2014 at 7:48 PM, Chandra Shekar < > chandrashekarb@gmail.com> wrote: > >> Hi, >> >> am tr

Re: $$Excel-Macros$$ On time Issue

Hi In first code add at the end this line.. Call Ontime_PivotRefresh Cheers!! On Mon, Aug 11, 2014 at 7:48 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi, > > am trying to refresh pivot every one minute but its running first time and > its not enter there after may I know wha

$$Excel-Macros$$ On time Issue

Hi, am trying to refresh pivot every one minute but its running first time and its not enter there after may I know what is problem in the code. Thanks in advance. Sub PivotsRefresh() Dim sh As Worksheet Dim pt As PivotTable MsgBox "Enter..." For Each sh In ActiveWorkbook.Sheets 'sh1 = sh.Na