excel automatic add-ing

L

luis

the automatic add-ing stop working. i uninstalled the program and reinstalled again, but did not fix the problem. I used tthe fix and repair option but did not fix the problem either.. I check Works and the automatic add-ing is not working either. What should i do to solve the problem?
 
G

Gord Dibben

Luis

The most common reason auto adding does not work is that Calculation is set to
"Manual" in Tools>Options>Calculation. Change to "Automatic".

Second most common reason is that the cells that look like numbers are
actually Text.

Copy a blank cell then select the range of "number" and Paste
Special>Add>OK>Esc.

If you have the same problem in both Excel and Works, I would go for the
second solution.

Gord Dibben XL2002
 

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

Top