Formulas Not Calculating 1

[cLFlaVA]

Hello-

I've been working with an excel application that I created. Today, for seemingly no reason, the formulas will not calculate within the cells until I save the file.

ie:

if I have a formula, =A1*A2, in a cell, and enter 5 and 10 into cells A1 and A2, nothing happens. However, when I hit Ctrl+S, the file saves and the formulas calculate.

Did some Excel setting change that I don't know about?

Thanks a lot,

c.

 

[Molby]

Try under Tools, Options, Calculation, there is an option for manual and automatic, make sure the automatic one is set.

 

[cLFlaVA]

Thanks for reading...

I found my answer after more searching.

Tools > Options > Calculations > Automatic.

Does this get set to manual after a certain number of rows?

Thanks,

c.

 

[Molby]

Not that I know of, I regularly use quite a few calculations, and pivots etc, and I've never had it switch for me. One of the other guys might ne able to confirm.

 

[xlbo]

nope - you have to set it manually (or via code) - there is no "switch" which will make excel do this itself

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[GlennUK]

Hi Geoff,

what about the case where the first workbook opened in an Excel session that was previously saved with Manual Calculation ( recalc on save ) as its setting, and then afterwards opening another book.

The second book open ( if the first book has been left open in the Excel workspace ), will inherit the calculation settings of the first workbook for this session, even if it had been saved with a calculation setting of Automatic. To a user it will appear as though this workbook has suddenly had it's setting changed.

This, of course, can be very confusing.

Cheers, Glenn.

 

[xlbo]

This, of course, can be very embarrasing to Geoff

Course, you are right Glenn - I should've thought of that !!

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[barbola]

If the calculation method is set to manual for a reason, you can hit F9 to calculate. Sometimes I turn off automatic because it takes a long time to calculate.

Thanks!
Barb E.