Specifically, the first formula worked fine, but when we copied it, the formula returned the result of the first formula. In the example sheet, I entered a SUM() function to total each salesperson's commission (row 8) and bonus (row9).Nrobinson5 suggested that the formula uses absolute references: instead of =SUM(B8: B9), I entered formula =SUM($B:$B).You must remember to switch the calculation mode back to Automatic. Choose Options under Help, and then choose Formulas in the left pane.
The option is located in the options panel, under 'Advanced' options.
That setting affects all the other workbooks the you open during that session.
In this case, the workbook calculation was set to Automatic on all the machines – that’s the first thing we checked.
Dogknees was the first to mention that the calculation method might be set to Manual - and that is the problem, but as bill.kuunders mentioned, it gets worse.
This isn't a case of the calculation switch being flipped for a single workbook.