software

Hi. My question is a very basic one..

When I am copying/pasting formulas that I use every so often, Excel
will automatically re-calculate the values based on the new position
(thank God). However, it will only show these new values once I save.
This is a pain for me because I have to save every 5-10 seconds to make
sure that I am not making a mistake. How do I set it so that the new
values are automatically shown when I paste the formula to a new area?--
ArenaNinja
------------------------------------------------------------------------
ArenaNinja's Profile: www.excelforum.com/member.php...oamp;userid=33624
View this thread: www.excelforum.com/showthread...hreadid=542296Tools --gt; Options --gt; Calculation Tab --gt; Check Automatic Calculations

HTH,
Elkarquot;ArenaNinjaquot; wrote:

gt;
gt; Hi. My question is a very basic one..
gt;
gt; When I am copying/pasting formulas that I use every so often, Excel
gt; will automatically re-calculate the values based on the new position
gt; (thank God). However, it will only show these new values once I save.
gt; This is a pain for me because I have to save every 5-10 seconds to make
gt; sure that I am not making a mistake. How do I set it so that the new
gt; values are automatically shown when I paste the formula to a new area?
gt;
gt;
gt; --
gt; ArenaNinja
gt; ------------------------------------------------------------------------
gt; ArenaNinja's Profile: www.excelforum.com/member.php...oamp;userid=33624
gt; View this thread: www.excelforum.com/showthread...hreadid=542296
gt;
gt;

Go to the Tools menu / Options / click the Calculations tab and mark
Automatic.

edIf Elkar and Edcosoft's suggestions aren't what your looking for I do beleive
F9 would refresh the formulae

quot;ArenaNinjaquot; wrote:

gt;
gt; Hi. My question is a very basic one..
gt;
gt; When I am copying/pasting formulas that I use every so often, Excel
gt; will automatically re-calculate the values based on the new position
gt; (thank God). However, it will only show these new values once I save.
gt; This is a pain for me because I have to save every 5-10 seconds to make
gt; sure that I am not making a mistake. How do I set it so that the new
gt; values are automatically shown when I paste the formula to a new area?
gt;
gt;
gt; --
gt; ArenaNinja
gt; ------------------------------------------------------------------------
gt; ArenaNinja's Profile: www.excelforum.com/member.php...oamp;userid=33624
gt; View this thread: www.excelforum.com/showthread...hreadid=542296
gt;
gt;