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).

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.

FYI... 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.

Ask Your Question

Weekly Poll

Do you trust smart speakers to not spy on you?

Discuss in The Lounge

Poll History