Refreshing drop down cell values...
 

I have a spreadsheet with formulas that callculate cell values based on the
values of drop-down list cells.

For example:
Cell1 has a drop down list of 'High', 'Medium' and 'Low'.
Cell1 is displaying 'Medium'.

Cell2 has a formula that refrences Cell1 and displays a corresponding
numeric value. e.g. if Cell1 is 'High' Cell2 value is '9'. If Cell 1 is
"Medium' then cell2 value displays '5'. If cell1 is 'Low' then cell2 displays
'1'.

Cell 2 is currently displaying 1.

When I do a CTRL-ALT-F9 to refresh the formulas, nothing changes.
When I reselect Medium in the cell1 drop down list, then cell2 correctly
changes to display '5'.

I have hundreds of these! How do I refresh all the drop down list cell
values, so that the corresponding cell formulas will automatically update,
without selecting the value in the drop down list manually?

Thanks in advance...