Formulas not updating until file is saved
 

I'm using Excel 2003 11.5612.5606.

I recreated one of our workbooks that has various formulas in it. Some
of which are just something like =A1 where A1 contains the customer
name. The customer name doesn't show up in that cell until after the
file is saved.

What did I do wrong?


--
Tech
------------------------------------------------------------------------
Tech's Profile: http://www.excelforum.com/member.php...o&userid=15107
View this thread: http://www.excelforum.com/showthread...hreadid=492762

Formulas not updating until file is saved
 

The file is probably set for manual recalculation - you can press F9 to
recalculate at any time. To set it for automatic recalculation, select
Tools | Options | Calculation Tab.

Pete

Formulas not updating until file is saved
 

That was it. Thanks!


--
Tech
------------------------------------------------------------------------
Tech's Profile: http://www.excelforum.com/member.php...o&userid=15107
View this thread: http://www.excelforum.com/showthread...hreadid=492762