Linked cells don't automatically update in Excel 2003. Why?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jrwrm - 31 Aug 2006 21:28 GMT

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!

Reply to this Message

Dave Peterson - 31 Aug 2006 22:51 GMT

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.

> 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
[quoted text clipped - 4 lines]
> of my workbooks have fifty or more worksheets, so this is becoming a real
> problem. Help!

Signature

Dave Peterson

Reply to this Message