Copying formulas

[ArenaNinja]

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?

[Elkar]

Tools --> Options --> Calculation Tab --> Check Automatic Calculations

HTH,
Elkar


"ArenaNinja" wrote:

>
> 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: http://www.excelforum.com/member.php...o&userid=33624
> View this thread: http://www.excelforum.com/showthread...hreadid=542296
>
>

[[email protected]]

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

ed

[Abode]

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

"ArenaNinja" wrote:

>
> 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: http://www.excelforum.com/member.php...o&userid=33624
> View this thread: http://www.excelforum.com/showthread...hreadid=542296
>
>