Formulas not updating until save
 

I have Excel 2003 and I noticed that a lot of my formulas in a
particular worksheet are not updating if I change the values that they
depend on until I save the sheet. Is there a workaround for that?


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=465868

DKY,

Set your calculation mode to automatic. Tools / Options / Calculation tab.

HTH,
Bernie
MS Excel MVP


"DKY" wrote in message
...

I have Excel 2003 and I noticed that a lot of my formulas in a
particular worksheet are not updating if I change the values that they
depend on until I save the sheet. Is there a workaround for that?


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=465868

it is on automatic. Is there any thing else?


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=465868

Select all the cells.
edit|replace
what: =
with: =
replace all

Maybe it'll wake excel up.

DKY wrote:

I have Excel 2003 and I noticed that a lot of my formulas in a
particular worksheet are not updating if I change the values that they
depend on until I save the sheet. Is there a workaround for that?

--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=465868

--

Dave Peterson