I have a similar problem in Excel 2003. A cell linked to another cell in a
different worksheet in the same workbook does not update unless one or other
of the two cells is manually edited. Yet a later version of the same
workbook updates correctly. There are no links to external files and
calculation is set to manual.

I suspect that somehow Excel has lost track of whether the cell has been
updated or not (it only recalulates changed cells or cells based on changed
cells) as at one stage I had the "Iterations" option unticked. In the later
version of the file I ticked that option. However I cannot recreate the
error which is frustrating, so I cannot confirm this hypothesis.

Interesting that George P and I have both had the same or similar problems
within a few weeks, 2 years after the initial posting.

"George P" wrote:

I run into the exact situation as #1 below. The settings for calculation are
set to auto, but i still have to double-click in one of the cells in order
for all to recalculate.

In an unrelated Excel problem, I have successfully built links in several
spreadsheets/workbooks, however, on occassion, cells do not update/refresh
upon opening and "updating". Sometimes I have to open the supporting sheets
or books, save them and then re-open my target sheet and select update, then
the values are updated. Why is this?

George P.


"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?