S shaking Registered User Messages 485 10 Apr 2008 #1 In the last few days my excel has stopped auto calcing, if I change a figure in a spreadsheet none of the values change unless I go into each one (F2) and enter out again then it performs the calculation. Any tips on how to sort this?
In the last few days my excel has stopped auto calcing, if I change a figure in a spreadsheet none of the values change unless I go into each one (F2) and enter out again then it performs the calculation. Any tips on how to sort this?
S Sunny Registered User Messages 4,570 10 Apr 2008 #2 Go into tools, then options, calculation tab and make sure automatic and not manual is ticked
F flattea2 Registered User Messages 229 10 Apr 2008 #4 Quick tip - Some people (a la me!) like to keep the auto calc off. If you wish to do so, pressing F9 will refresh all formula on the worksheet.
Quick tip - Some people (a la me!) like to keep the auto calc off. If you wish to do so, pressing F9 will refresh all formula on the worksheet.