Excel 2010 Help!- My cells don't update
I have my excel model on manual and have been hitting F9 repeatedly but still my cells don't update. A short term fix I discovered is to select all my cells in the worksheet and replace = with = to "wake-up" excel. However, I need a long term fix or I have to rebuild this model from scratch. What do you think I should do?
Go into file -> options and make sure you have iterative calculations enabled. Also I thought f2 -> enter updated cells?
This and make sure you have the calculations set to automatic
If neither of the above work, just copy formulas to a new worksheet, check that it works properly there, then copy over formatting.
Iterate them cells patna
Throw a can of mountain dew at the screen
Provident officia corporis sint officiis. Quos placeat est dolorum optio voluptatem explicabo.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...