D
duoduo76
I have a Excel 2007 spreadsheet set up to use Scenario Manager. When I
choose a different scenario and hit F9 to recalculate, not all cells
seem to be recalculated unless I turn off or re-apply the auto filter
(e.g. a cell should have a number now but still shows "--" in it). It
only happens to cells that should switch between "--" and numbers. The
same workbook runs fine in Excel 2003. Is there a calculation option
or display option I need to check to fix this? Any advices to get
around this is appreciated! Thanks in advance!
choose a different scenario and hit F9 to recalculate, not all cells
seem to be recalculated unless I turn off or re-apply the auto filter
(e.g. a cell should have a number now but still shows "--" in it). It
only happens to cells that should switch between "--" and numbers. The
same workbook runs fine in Excel 2003. Is there a calculation option
or display option I need to check to fix this? Any advices to get
around this is appreciated! Thanks in advance!