Hi,
I'm in Excel 2007 and have had the same problem. Automatic calculation is
on and pressing F9 doesn't work. We have been able to reproduce the problem
on simple worksheet with no
VB and very few formula. The numbers in the
spreadsheet are correct but the chart is still showing the previous values.
Changing to page layout view, altering some values and then changing back to
normal view (a "solution" I found on a different discussion group) seems to
sort the problem for future changes as well as previous, as does crashing the
Excel file and using the autorecover version of the spreadsheet. However,
these are not ideal "solutions" and not every-one will notice that the chart
hasn't updated and certainly won't know to change to layout view.
I'll be looking out for the next office update