Solved Cells not updating automatically

October 15, 2013 at 22:44:11
Specs: Windows 7
I am using excel 2007, i have added my formulas into the cell I need but it doesn't automatically update the answer when I enter the data into the cells within the formula?

See More: Cells not updating automatically

October 16, 2013 at 04:42:04
✔ Best Answer
Go to Options and under Forumulas make sure 'Workbook Calculations' is set to 'Automatic'

just another note, the sheet will only update once the cell that you are entering data into looses focus, ie you enter the data and click another cell, or press the enter key.

Report •

October 16, 2013 at 15:36:09
That worked! Thank you so much you are awesome!

message edited by cburden

Report •

October 17, 2013 at 05:50:59
Welcome mate glad it work out :)

Report •
Related Solutions

Ask Question