Cells don't update!!

[aposatsk]

I have two sheets which contain linked cells. In sheet 2, one cell is:
"='HL3 (500)'!B39" which means that it has to look at sheet named
HL3(500) which is previous to it. However, the cell does not
automatically update when i change the first sheet. In fact, only when
i click into the cell to edit it, does the updated value appear.

Why!? I can't keep clicking each cell to update it.

 

[L. Howard Kittle]

Perhaps your sheet is set to Manual Calculation. Tools > Options >
Calculation > Automatic.

HTH
Regards,
Howard

 

[aposatsk]

Thank you, but its NOT on manual calculation. There must be anothe
solution.

Let me rephrase:
blank cells that should contain values do not, and the values onl
appear once i click into the cells as i would when i edit a cell. then
upon pressing enter, the value appears

 

[Niek Otten]

http://xldynamic.com/source/xld.xlFAQ0024.html


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| I have two sheets which contain linked cells. In sheet 2, one cell is:
| "='HL3 (500)'!B39" which means that it has to look at sheet named
| HL3(500) which is previous to it. However, the cell does not
| automatically update when i change the first sheet. In fact, only when
| i click into the cell to edit it, does the updated value appear.
|
| Why!? I can't keep clicking each cell to update it.
|
|
| --
| aposatsk
| ------------------------------------------------------------------------
| aposatsk's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36709
| View this thread: http://www.excelforum.com/showthread.php?threadid=573213
|

 

[Dave Peterson]

Sometimes this works.

Select a single cell.
edit|replace
what: = (equal sign)
with: =
replace all

It's like reentering each formula--but easier.