Respected sir
I hv a excel issue on my win 7
The average of the data not changed wen i change my data the formula is correct n every thing is correct but there is an issue
Wen i save the file the data is instantly changed
Kindly resolve my issue
Excel 2006
Yeah Microsoft
I hv a problem in data entry
Wen i change my data the sub total can't Chnge
The formula is correct
Please tell me if Excel is part of Office on your computer. There is no Excel 2006, the versions of Excel are, starting from Excel 2003:
Excel 2003
Excel 2007
Excel 2010
Excel 2013
Excel 2016
Sorry microsoft excel 2003
Showing that results of formulas may b out of date. bcs excel is not set to calculate automatically. press f9 to recalculate manually
Yeah i got it
Click the Microsoft Office Button , click Excel Options, and then click the Formulas category. Automatic except for data tables Formulas recalculate, unless the formula is in a data table. Recalculate workbook before saving This option is available only if Workbook Calculation is set to Manual.
Quote