excel 2003sp3 not evaluating

  • Thread starter Thread starter strummer
  • Start date Start date
S

strummer

I am using excel 2003 and it is not evaluating formulas. I have a spreadsheet
that was created in office 97 and it works fine and worked fine in 2003 up
until recently.

I use the sheet in 97 and the formulas are not complex (cell C3=A3*B3) and
it works but does not work in 2003. If I go into a new sheet in 2003, and
set up that formula, it works. If I go back and change a value in A3 or B3,
the answer does not update. So I go back and reinput the formula and it works
but changing the values results in no change of the answer.

As mentioned, I am running 2003 sp 3

Thanks in advance
 
Hi Strummer,
I use the sheet in 97 and the formulas are not complex (cell C3=A3*B3) and
it works but does not work in 2003. If I go into a new sheet in 2003, and
set up that formula, it works. If I go back and change a value in A3 or B3,
the answer does not update. So I go back and reinput the formula and it works
but changing the values results in no change of the answer.
Click to expand...

Calc set to manual? Tools, Options, calculation tab.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
 
Back
Top