D
Dyce
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...
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...