Linked cells don't automatically update in Excel 2003. Why?
Make sure that calculation is set to automatic.
tools|options|calculation tab
If that doesn't help, sometimes this helps.
Select all the worksheets (rightclick on a worksheet tab and choose "select all
sheets"
select a single cell on the activesheet
edit|replace
what: =
with: =
replace all
rightclick on any of the grouped worksheets and choose "ungroup sheets"
It's kind of like reentering all the formulas in one giant swoop.
And maybe it'll wake up excel's calculation engine.
jrwrm wrote:
I have Excel 2003, and get automatic Office updates. Lately, I've noticed
that some linked cells do not automatically update when I change the value or
formula in the original cell. I have to click on the linked cell and hit
enter before the cell will update with the changed value. There seems to be
no pattern for which linked cells update and which do not (for example, the
original cell may have a percentage, a constant value, or a formula). Some
of my workbooks have fifty or more worksheets, so this is becoming a real
problem. Help!
--
Dave Peterson
|