Formula not updating

K

Katie

I am using very basic formula to calculate sums on a spreadsheet, and usually
it works fine, but for some reason they are no longer updating? Does anyone
know why? The formula still seems to be in the cell, but it doesn't change
when I amend the numbers above it.
Using Excel 2003.
 
T

T. Valko

Make sure calculation is set to automatic.

Tools>Options>Calculation tab>Automatic>OK
 
K

Katie

Thanks so much! For some reason it had been changed to Manual, and now I have
changed it back to automatic it is working fine again.
Thanks again! That was driving me crazy :)
 

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

formulas updating 2
Formula not updating 1
Simple Formula displays "0" 1
formula error 5
Unvaried date as part of a formula 1
Keyboard shortcut to 'Formula Bar' ? 5
formula not working 4
Change date to Day Name 1

Top