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...o&userid=36709
View this thread: http://www.excelforum.com/showthread...hreadid=573213