Spreadsheet not calculating

G

Gazzr

Hi,

I am having problems with a spreadsheet where the formulas are not
re-calculating, even though auto calc is on.

If i hit F2 on the formula and then enter it works though.

Any ideas?

Garry
 
E

edcosoft

Increase the number of iterations (same screen where you turn on
auto-calculate). Increase it to 100 and see if that helps. ed
 
E

edcosoft

Increase the number of iterations (same screen where you turn on
auto-calculate). Increase it to 100 and see if that helps. ed
 

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

Sprdsht not calculating 3
Excel Calculate on status bar 1
Formulas don't calculate until SAVE (excel 2000) 2
Calculating Time Dependent User Defined Functions 3
Calculate message 3
Calculating Cells causes Excel to stop responding 1
formulas correct yet not calculating until reopening file 1
Formatting Time to do Calculations within Excel 3

Top