ADDITIONAL FIGURES IN COLUMN DON'T ADD TO TOTAL IN EXCEL

G

Guest

on my spreadsheet a totals formula, in this case, =Sum(D1:D35), will not
change when new figures are added to the column unless I double click and
then enter in the total cell, how can i make this work automatically as it
usually does. my spreadsheets are on a floppy disk - does this make a
difference?
 
G

Guest

Keeping files on a floppy is OK, so long as you don't open them from the
floppy. Doing so is a prescription for file corruption, so copy them to the
hard drive before opening them.

The calculation problem sounds as though calculation has been set to manual.
Change it by using the menu to select

Tools>Options>Calculation>Automatic.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two Calculations in one column 4
formula to add year to date figures 3
TRUNC zero giving odd results? 5
Simple totals 4
How to set cell value to emptry if three other columns are empty too 1
Adding certain cells in one column 4
Adding variable number of columns 8
addition total is wrong 2

Top