Inhibit auto-calculate for *some* cells
Posted by Bengt J on September 09, 2001 6:34 AM
I would like to freeze some values, and still be able to recalculate some other cell values.
The actual problem is this: I tried to make a multiplication exercise for my kids, so I wanted the factors to be generated with the RAND function. Then the kids would fill in the answers, and pressing F9 for manual recalculation would fill in some "Bravo!" or "Sorry, error." according to their answers.
However, F9 also recalculates the random numbers, thus losing the old exercise. The kids' answers are still there, but now compared to a new exercise! Of course, this is almost always wrong.
Any suggestion, anyone? Do I have to learn macros and create one "New exercises"-button and one "Check my answers"-button? There must be a simpler way...