$$Excel-Macros$$ Re: Calculation Automatically Not Updating.

Hi Anjali, Please set the below option in your workbook. Tools -> Options -> Formulas -> Calculation Options -> Automatic -> Click Ok Regards Prince On Tuesday, November 13, 2012 12:41:27 AM UTC+5:30, Anjali . wrote: > > Hi Everyone, > Please be find the attached excel file in which i am fac

Re: $$Excel-Macros$$ Re: Calculation Automatically Not Updating.

Prince ji happy diwali, i thing me want to share wid u why u always share wid new mail, why dont wid related quary? thanks On Wed, Nov 14, 2012 at 8:39 AM, Prince wrote: > Hi Anjali, > > Please set the below option in your workbook. > > Tools -> Options -> Formulas -> Calculation Options ->

Re: $$Excel-Macros$$ Re: Calculation Automatically Not Updating.

Hi Anjali, You can also try.. Sub Test() Application.Calculation = xlCalculationAutomatic End Sub On Wed, Nov 14, 2012 at 8:39 AM, Prince wrote: > Hi Anjali, > > Please set the below option in your workbook. > > Tools -> Options -> Formulas -> Calculation Options -> Automatic -> Click > Ok >