Busby Posted August 3, 2007 Report Share Posted August 3, 2007 Something odd seems to have happened to all of my spreadsheets that contain formula's. Until tonight, when I entered new data on these sheets the calculation would automatically take place as the formula was pre-populated into the cells. However, even though the forumal still shows, when I put data into the cells involved in the formula the cell where the result should appear stays balnk until I double click on it to bring the fromula up and then press Enter to confirm it. EG If I enter the formula =A1+A2 in cell A3 and then enter a 2 in A1 and a 2 in A2, A3 stays as 0 until I open the formula up again and confirm it. Anyone got any idea what I need to change to make all the sheets go back to working things out automatically when I enter data into the cells? Cheers Link to comment Share on other sites More sharing options...
Muppetboy Posted August 3, 2007 Report Share Posted August 3, 2007 Try Tools>Options>Calculations> and ensure automatic is ticked Link to comment Share on other sites More sharing options...
Busby Posted August 4, 2007 Author Report Share Posted August 4, 2007 [ QUOTE ] Try Tools>Options>Calculations> and ensure automatic is ticked [/ QUOTE ] Simply as that - you da man, Muppetboy! Thanks very much Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now