Sometimes this works.

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

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

aposatsk wrote:

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

--

Dave Peterson