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

[Gary''s Student]

Try CNTRL-ALT-F9
--
Gary's Student


"susang" wrote:

>
> 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
>
>
> --
> susang
> ------------------------------------------------------------------------
> susang's Profile: http://www.excelforum.com/member.php...o&userid=28311
> View this thread: http://www.excelforum.com/showthread...hreadid=482051
>
>

[susang]

thanks, but it doesn't work also

[Gary''s Student]

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
--
Gary's Student


"susang" wrote:

>
> thanks, but it doesn't work also
>
>
> --
> susang
> ------------------------------------------------------------------------
> susang's Profile: http://www.excelforum.com/member.php...o&userid=28311
> View this thread: http://www.excelforum.com/showthread...hreadid=482051
>
>

[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