Re: change...

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

The only way to truly lock in the value of a formula is to replace it with
its value. If you change calculation mode to manual (Tools, Options,
Calculation) then the formula's value (and all formulas values) will be
maintained until you force a calc by pressing F9.

--
Jim
"alen_re" <alen_re.21uf3z_1137609001.3528@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:alen_re.21uf3z_1137609001.3528@xxxxxxxxxxxxxxxxxxxxxxxx
|
| :eek:
| I have a 'simple ?' question..
|
| If I have 2 sheets..
| In sheet1.. A1: 5 (lets say)
|
| In sheet2.. A1: =Sheet1!A1
|
| I want to leave number that I've got from sheet1.. when I change number
| 5 into something else.. so that I can change sheet1 A1: to *10*, and to
| have number 5 in sheet2, becouse it calculated it before..
|
| Sorry for my English if you don't understand me..
|
| Thanks for help..
|
|
| --
| alen_re
| ------------------------------------------------------------------------
| alen_re's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=28331
| View this thread: http://www.excelforum.com/showthread.php?threadid=502579
|


.

Quantcast