Excel 2003 workbook not updating values

  • Thread starter Thread starter PJ
  • Start date Start date
P

PJ

I have a 75+ worksheet 2003 workbook that recently stopped reliably updating
linked formulas and recalculating function formulas. "CALCULATE" appears in
the status bar although the the spreadsheet option is set to automatically
calculate. Ctrl Alt F9 and F9 do not seem to force a recalculation.

Editing the formulas, for example, by changing instances of "=" to "a=" and
then edit back from "a=" to "=" will force spreadsheet to recalculate the
edited formulas.

Is there a reason for this behavior? I am baffled!
 
PJ said:
I have a 75+ worksheet 2003 workbook that recently stopped reliably
updating
linked formulas and recalculating function formulas. "CALCULATE" appears
in
the status bar although the the spreadsheet option is set to automatically
calculate. Ctrl Alt F9 and F9 do not seem to force a recalculation.

Editing the formulas, for example, by changing instances of "=" to "a="
and
then edit back from "a=" to "=" will force spreadsheet to recalculate the
edited formulas.

Is there a reason for this behavior? I am baffled!
Click to expand...

I think this can happen if you have a circular reference - perhaps even an
obscure, indirect one. It does so many iterations and then stops. Have you
made changes recently?
 
Back
Top