Copy/Paste of formulas error

Microsoft Office excel 2007 - upgrade
February 11, 2011 at 07:35:12
Specs: Windows XP Version 2002 SP 3, 2.2GHz Intel Core processor, 2GB RAM
I am a long-time advanced user of Excel and have never encountered this error, hope someone can help.

In column B, I have a formula that simply sums the contents of cells above. I copy/pasted (actually used the crosshairs to drag the formula across) that formula to adjacent cells, so that the sums of C, D, etc. would also calculate. Although the formula bar shows the correct formula for each column using the relative cell addressess (ex: =SUM(B4:B26) for column B, =SUM(C4:C26 for column C), the numerical result displays only the calcuated answer for the first column (ex: 97 shows across the board for all column sums, but if I individually type in the formula for each column it would calculate correctly).

See More: Copy/Paste of formulas error

Report •

February 11, 2011 at 07:43:03
Found the solution in another forum:
Under the Formulas tab, select the Calculation section, and click on Calculation Options. Ensure that "Automatic" is selected - for some reason, mine had been set to "Manual". This fixed the problem.

Report •

February 11, 2011 at 08:16:08

If the first workbook opened during in an Excel session has the calculation set to manual, then all other workbooks opened during that session will be set to manual.

If I'm not mistaken, if the workbooks are then saved, the manual setting will be saved.

You could test that to be sure, but odds are that at some point you had a workbook set to manual and the "problem" workbook inherited that setting.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

Ask Question