Excel Do not calculate

  • Thread starter Thread starter Boris Dubov
  • Start date Start date
B

Boris Dubov

Sometimes (not every time) Excel do not calculate
different formulas when recalculating worksheets
manually. Moreover it can calculate them in some sells
and donot calculate in others. All formulas are correct,
when you enter a cell and press "Enter" the needed result
is given.

WorkBook is configured to be recalculated manually.

Thanks.
 
Try forcing a complete recalc:

This is from xl2002's help:

Calculate a worksheet or workbook now

Press F9 Calculates formulas that have changed since the last calculation, and
formulas dependent on them, in all open workbooks. If a workbook is set for
automatic calculation, you do not need to press F9 for calculation.

Press SHIFT+F9 Calculates formulas that have changed since the last
calculation, and formulas dependent on them, in the active worksheet.

Press CTRL+ALT+F9 Calculates all formulas in all open workbooks, regardless of
whether they have changed since last time or not.

Press CTRL+SHIFT+ALT+F9 Rechecks dependent formulas, and then calculates all
formulas in all open workbooks, regardless of whether they have changed since
last time or not.

(I think that the last one is new with xl2002.)
 
Back
Top