Can excel formulas become frozen?

J

Joni

Can formulas become frozen?

I have a worksheet containing a basic percentage formula
(100-(100/B1)*C1)
This formula was working perfectly and producing the expected result
when it was originally entered. I then saved and closed the worksheet

When the worksheet was reopened and the figures in columns B and C wer
changed, the previous result did not alter. If you retype the formula i
each individual row it works ok again, but no amount of copying, pastin
makes the original formula work.
This applies to two other formulas on the same worksheet. It is almos
as if they have become disconnected from the cells they are supposed t
be reading.

Any suggestions as to why and what I can do to fix it?
It would be a real pain to reenter all the formulas on all the sheets.

Thanks, Joni
 
N

Niek Otten

Hi Joni,

Probably Calculation is set to Manual (Tools>Options>Calculation>Manual)

This is a setting for all open workbooks, which means that if you have a
workbook opened first which has this setting, and then open another
workbook, that last workbook will have Manual Calculation as well, no matter
what the original setting was.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
D

David McRitchie

If you don't know how calculation is being turned off, and it keeps
happening, then you probably have a macro or even an addin that
is turning it off. It would help if you can tell when it happens. Some
suggestions that might help.
http://www.mvps.org/dmcritchie/excel/slowresp.htm#addins

The first workbook you open will probably be your personal.xls
workbook. So might want to unhide it and put the calcualtion to
automatic, hide the workbook, and save your personal.xls
which you can do from the VBE.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Niek Otten said:
Hi Joni,

Probably Calculation is set to Manual (Tools>Options>Calculation>Manual)

This is a setting for all open workbooks, which means that if you have a
workbook opened first which has this setting, and then open another
workbook, that last workbook will have Manual Calculation as well, no matter
what the original setting was.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
Click to expand...
 
Top