Hi,

Check the options: Tools - Options - Calculation. You can apply settings
that automatically calculates each time it registers a change to a value that
is used in calculations. Alternatively you can change it so that you have to
manually tell it to calculate each time.

F9 re-calculates the workbook.

When you have such great capacity Excel may struggle to calculate - check
your status bar and it will report back on how far through the calculation
process it is as a percentage.

Cheers,
Jon

"notloiseweiss" wrote:

(Excel 2002) I have a 5G Excel workbook with around 40 worksheets in it.
Many of the sheets contain cells that refer to values in other sheets. I
recently found that some of the values were incorrect (I believe they were
just not updated). When I double clicked on the cell, gained access to the
formula and then hit enter, the cell updated. I'm wondering 2 things -

1) Under what circumstances will cells NOT automatically update? I thought
they always updated automatically as long as you're working within the same
workbook.

2) Is there a way that I can update all cells at once?