OK this thing actually helped me..
Thanks for the help... Thanks everyone for posting..


Jim Rech Wrote:
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" wrote
in
message ...
|
|
| 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...o&userid=28331
| View this thread:
http://www.excelforum.com/showthread...hreadid=502579
|


--
alen_re
------------------------------------------------------------------------
alen_re's Profile: http://www.excelforum.com/member.php...o&userid=28331
View this thread: http://www.excelforum.com/showthread...hreadid=502579