ExcelBanter - How to get sum totals to auto calculate when changes made?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to get sum totals to auto calculate when changes made? (https://www.excelbanter.com/excel-worksheet-functions/183561-how-get-sum-totals-auto-calculate-when-changes-made.html)

Bern.

How to get sum totals to auto calculate when changes made?

I've set up a spreadsheet with dollar amounts and totals. When I make
changes to the dollar amounts, the totals do not automatically change. How
do I fix this? I've never had this problem before.

Don Guillett

How to get sum totals to auto calculate when changes made?

??
toolsoptionscalculationautomatic

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bern." wrote in message
...
I've set up a spreadsheet with dollar amounts and totals. When I make
changes to the dollar amounts, the totals do not automatically change.
How
do I fix this? I've never had this problem before.

David Biddulph[_2_]

How to get sum totals to auto calculate when changes made?

Tools/ Options/ Calculation:
Set to Automatic, not Manual.
--
David Biddulph

"Bern." wrote in message
...
I've set up a spreadsheet with dollar amounts and totals. When I make
changes to the dollar amounts, the totals do not automatically change.
How
do I fix this? I've never had this problem before.

All times are GMT +1. The time now is 02:47 PM.