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

  • Thread starter Thread starter Tom Joseph
  • Start date Start date
T

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.
 
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
 
Back
Top