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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

difference between Alt-Control-Shift-F9 and Ctrl-H Replace = with 2
Ctrl+Alt+F9 not performing Full Recalculation on some PCs 4
Forcing to recalculate 7
Excel 2007 - Recalc or NOT 2
Multithreading bug? 4
Excel 2003 workbook not updating values 1
cell does not recalc 3
Recalculation does not work 8

Back
Top