Excel - the sums are not automatically calculating

T

Teresamlo

I have my excel spreadsheets and set up the autosum, both manually and using
the approciate keys however they do not automatically updating the totals, I
have to go to the total bank and reclick and enter to get it to update.

Please help
 
T

T. Valko

Make sure calculation is set to automatic.

Tools>Options>Calculation tab>Automatic>OK
 
S

Shane Devenshire

Hi,

If you are on manual recalculation you can force most calculations by press
F9.
 

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

Turning off automatic calculation 0
Integrating information from Word to Excel (not mail merge) 1
Auto Sum not working correctly 1
An Odd problem with SUM using : 0
Auto Sum Function 3
Problem activating pre-installed MS Office home and Student 0
Calc sometimes off by a penny 5
Embed the same Excel multiple times 0

Top