The autocalculation function has most likely been set to calculate
manually. This is an option that you can change in the tools -
options- calcualtion tab. If it a large file and takes a long time to
calculate, or if it is your preference to keep in as a manual calc file,
simply press the F9 key to manually calculate the workbook, or press
shift F9 to manually calculate the avtiveworksheet.


--
barrfly

Excel User - Energy markets
------------------------------------------------------------------------
barrfly's Profile: http://www.excelforum.com/member.php...fo&userid=4141
View this thread: http://www.excelforum.com/showthread...hreadid=392484