Recalc problem - and does not respond to Ctrl-Alt-F9

[Tom Joseph]

I have a complex workbook that on occassion does not refresh and recalculate
some key formulas that are used in a chart.

The workbook is set to recalculate manually.

Sometimes certain cells recalculate, and others do not. F9 does not cause
these formulas to recalculate and Ctrl-Alt-F9 does not work either.

If I save and reopen the workbook, the charts display the proper
recalculated info.

Any help appreciated.

 

[Charles Williams]

If you are using Excel 2002 or later try Ctrl-alt-Shift-F9 (rebuilds
dependency tree)

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

 

[xl_fr]

Hello,
try these following tip

use "save as" and the worksheet will be recalculate fully

or use in a VBA module the following code

sub calc
application.calculatefull ' in XL2000
application.calculatefullrebuild ' if in XL2003
end sub

all internals tables will be rebuilded.

Please answer if it's better now
guy