Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel web auto-refresh | Excel Discussion (Misc queries) | |||
Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
refresh a new worsheet on pivot table refresh | Excel Worksheet Functions | |||
How can I 'Enable Automatic Refresh' for Query Refresh by default | Setting up and Configuration of Excel | |||
Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) |