Solved Excel data entry issue

[khan034512]

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

 

[Ranger4]

Which version of Excel are you using & is it part of Microsoft Office?.

 

[khan034512]

Excel 2006

 

[khan034512]

Yeah Microsoft

 

[khan034512]

I hv a problem in data entry
Wen i change my data the sub total can't Chnge
The formula is correct

 

[Ranger4]

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

 

[khan034512]

Sorry microsoft excel 2003

 

[khan034512]

Showing that results of formulas may b out of date. bcs excel is not set to calculate automatically. press f9 to recalculate manually

 

[khan034512]

Yeah i got it

 

[khan034512]

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.

 

[khan034512]

Thnxx alot

 

[Ranger4]

Glad to hear you seem to have it fixed.