Automatic calculation is not working

[susang]

Hi,

It seems that Excel is not calculating the workbook/sheets properly
!!!!!
If I hits F9 or Shift + F9 does not always calculate the cells !!! I
tried to change the calculation modes (Automatic, manual) but nothing
helps.

When the problem occur the only way to calculate a cell is to enter the
cell, hit F2 and then hit Enter.

Somebody know what I change or if this is a bug on excel?

Thanks in advanced
Susan

 

[Guest]

Try CNTRL-ALT-F9

 

[susang]

thanks, but it doesn't work also

 

[Guest]

It may be that Excel think your formulae are text. Pull-down:

Edit > Find and select the = sign then replace with the = sign and select
replace all

 

[susang]

Nop :-(

I tried what you suggest column by column, all the worksheet and
nothing I have to hit F2 row by row to get the result

Any other idea?


Thanks
Susan