I am creating a workbook for a class assignment. So far, I have three sheets that create random addition, subtraction and multiplication problems, respectively. I also have a grades sheet, which lists the points received for each problem.

All of this seems to work fine, with one exception. My problem is that if I leave auto calculation on, then the random numbers are refreshed every time an answer is entered and it's impossible for it to be automatically graded. However, if I turn auto calculation off then in order to calculate grades the user would have to enter Shift+F9 on the grades sheet, and I don't think that should be necessary.

If anyone has any ideas on what to do to fix this, that would be great.