Copy Excel functions formula and auto refresh refresh
 

I have a problem with ms excel 2007. actually i have more than 10,000
records.

data entry function formula results
a1= 5, b1=1; -- c1==a1*b1 = c1= 5
a2=10,b2=4; -- c2==a2*b2 = c2=40
a3=8, b3=8; -- c3==a3*b3 = c3=64

but my output comes out differently.

the function formulas are the same but the results are differently.
they came out as the previous result. but when i double click it to
see the formula and enter back again, it auto refresh the data for me.
why it happens like that? i want to copy from the previous functions
and paste into new one and just changing the cell reference not the
answers from the previous cell. i have more than 10,000 cells with
records. is it i have to do one by one? please help me. it's really
urgent. thanks

Copy Excel functions formula and auto refresh refresh
 

On Feb 15, 8:11*am, Pauline Cheong wrote:
I have a problem with ms excel 2007. actually i have more than 10,000
records.

data entry * * * * * function formula * *results
a1= 5, b1=1; * -- c1==a1*b1 * = *c1= 5
a2=10,b2=4; * -- c2==a2*b2 * = *c2=40
a3=8, b3=8; * -- c3==a3*b3 * = * c3=64

but my output comes out differently.

the function formulas are the same but the results are differently.
they came out as the previous result. but when i double click it to
see the formula and enter back again, it auto refresh the data for me.
why it happens like that? i want to copy from the previous functions
and paste into new one and just changing the cell reference not the
answers from the previous cell. i have more than 10,000 cells with
records. is it i have to do one by one? please help me. it's really
urgent. thanks

Sounds like calculation is set to manual, set it back to automatic by
going to the tools menu=options=calculation (no idea where it is
located in xl'07),
or pressing F9 will recalculate the sheet

Copy Excel functions formula and auto refresh refresh
 

Turn on Automatic Calculation.

Office ButtonExcel OptionsFormulasCalculation


Gord Dibben MS Excel MVP

On Sun, 15 Feb 2009 07:11:10 -0800 (PST), Pauline Cheong
wrote:

I have a problem with ms excel 2007. actually i have more than 10,000
records.

data entry function formula results
a1= 5, b1=1; -- c1==a1*b1 = c1= 5
a2=10,b2=4; -- c2==a2*b2 = c2=40
a3=8, b3=8; -- c3==a3*b3 = c3=64

but my output comes out differently.

the function formulas are the same but the results are differently.
they came out as the previous result. but when i double click it to
see the formula and enter back again, it auto refresh the data for me.
why it happens like that? i want to copy from the previous functions
and paste into new one and just changing the cell reference not the
answers from the previous cell. i have more than 10,000 cells with
records. is it i have to do one by one? please help me. it's really
urgent. thanks

Copy Excel functions formula and auto refresh refresh
 

Hi,

If the previous suggestions do not work, you could try this:

Highlight the region and then do Ctrl + H. In the find box, type = and in
the replace box type =. Please select look in formulas.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Pauline Cheong" wrote in message
...
I have a problem with ms excel 2007. actually i have more than 10,000
records.

data entry function formula results
a1= 5, b1=1; -- c1==a1*b1 = c1= 5
a2=10,b2=4; -- c2==a2*b2 = c2=40
a3=8, b3=8; -- c3==a3*b3 = c3=64

but my output comes out differently.

the function formulas are the same but the results are differently.
they came out as the previous result. but when i double click it to
see the formula and enter back again, it auto refresh the data for me.
why it happens like that? i want to copy from the previous functions
and paste into new one and just changing the cell reference not the
answers from the previous cell. i have more than 10,000 cells with
records. is it i have to do one by one? please help me. it's really
urgent. thanks