Spreadsheet won't recalculate when numbers are changed.

C

c3peteo

I'm having trouble with my excell 2003 spreadsheets I have formulas in cells
that use a number to drive calculations in the soread sheet. the only way I
can to get the spreadsheet to recalculate is to go to each cell with a
formula, double click on it then hit enter for each cell. I know this isn't
the way it's supposed to work but I don't know what's wrong or how to fix the
problem. I'd appreaciate any suggestions.
Thank you.
 
T

T. Valko

Make sure calculation is set to automatic...

Tools>Options>Calculation tab>Automatic>OK
 

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