Excel 2000, Does not Recompute

[Martin]

I use a large (13MByte) Excel 2000 workbook in manual
compute mode, and update through F9.

Problem: Some worksheets do not update even after an F9.
Example: A cell in worksheet 1 references cell X68 in
worksheet 2. Worksheet 2 cell X68 holds value 993 after
some entries were made in worksheet 2 and F9. Worksheet 1
continues to show 946, the value before the entries in
worksheet 2 and F9.

 

[Elsa]

I have found that Excel will not automatically show the
recalculation of worksheets unless you physically open the
cell where it is at. So far, I do not know of any other
way to do it!

 

[Gord Dibben]

Elsa

Tools>Options>Calculation. Set to "Auto".

The first workbook opened in a session controls this setting.

Gord Dibben Excel MVP

 

[Martin]

Re-entering the reference into the cell that did not
update after F9 does cause the recalculation. Thanks for
the help.

Scary to think though that one has to reenter formula in
order to get a recomputation. Sounds like a bad bug to
me. And I didn't find anything about it in the MS
knowledge base.

 

[Martin]

I did want to keep computation at manual, since the
workbook has lots of formula and takes quite some time to
compute.

Shouldn't the F9 button cause a recompute, even when
Calculation is set to Manual?

F9 works, but not always.

Even saving the workbook (Option Recalculate Before Save)
did not result in recomputation.

I had to save the workbook with a different name in order
to get the recalculation done.

 

[Dave Peterson]

From xl2002's help for: Change when and how formulas are calculated

By default, Microsoft Excel automatically recalculates formulas when the cells
that the formula depends on have changed.

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.

===
That last one was added in xl2002.

So if F9 doesn't do what you expect, try shift-f9, then ctrl-alt-F9.

(or jump directly to ctrl-alt-f9)

 

[Martin]

CTRL+ALT+F9 does cause the recomputation that I expected.

Thanks for your help.