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

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

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

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

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


--
susang
------------------------------------------------------------------------
susang's Profile: http://www.excelforum.com/member.php...o&userid=28311
View this thread: http://www.excelforum.com/showthread...hreadid=482051