Copied formula produces unexpected copied results
My supervisor is working in excel 2007 and copied and pasted a formula down a
range/column of cells. The formula looks right but it posts the same results as the cell the formula was copied from. For example Cell A1 is 25, A2 is 25, A3 is =sum(A1+A2) showing 50. Copying that formula down the 3rd column posts the correct formula ie =sum(B1+B2), =sum(C1+C2). The information for exampe in B1 is 30, B2 is 30, C1 is 40 & C2 is 40 but the B3 and C3 are showing as 50. The same information as cell A1. This continues on down the page. If you go back and manually retype the formula, the results are corrected, showing B3 is 60 and C3 is 80. This problem is affecting every file sent to her from either 2003 or 2007 and even in new workbooks that she opens. It doesn't matter if she is copying across a row or down a column. Any Ideas? |
Copied formula produces unexpected copied results
Hi Robert
Sounds like calculation mode has got set to Manual. Press F9 to recalculate and all the values should change To alter the setting, ToolsCalculationAutomatic. Calculation mode gets set by the first workbook opened in that Excel session. Your Supervisor needs to take a look at that workbook, alter it's setting as well and save it, else the same thing is likely to happen again. -- Regards Roger Govier "Robert" wrote in message ... My supervisor is working in excel 2007 and copied and pasted a formula down a range/column of cells. The formula looks right but it posts the same results as the cell the formula was copied from. For example Cell A1 is 25, A2 is 25, A3 is =sum(A1+A2) showing 50. Copying that formula down the 3rd column posts the correct formula ie =sum(B1+B2), =sum(C1+C2). The information for exampe in B1 is 30, B2 is 30, C1 is 40 & C2 is 40 but the B3 and C3 are showing as 50. The same information as cell A1. This continues on down the page. If you go back and manually retype the formula, the results are corrected, showing B3 is 60 and C3 is 80. This problem is affecting every file sent to her from either 2003 or 2007 and even in new workbooks that she opens. It doesn't matter if she is copying across a row or down a column. Any Ideas? |
All times are GMT +1. The time now is 01:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com