formulas not calculating

[Guest]

I have a bunch of worksheets where the formulas work &
I have a bunch of work sheets where the formulas are not working unless I F2
and then hit enter on the cell.
I have checked tools,options, calculations & it is set to automatic.
The F9 key does not work either.

 

[Tom Ogilvy]

How about
Ctrl+shift+F9

 

[Guest]

Sorry Tom, That does not work

How about
Ctrl+shift+F9

 

[David McRitchie]

Hi Wade,
See if this helps
http://www.mvps.org/dmcritchie/excel/formula.htm#problems

 

[Tom Ogilvy]

David makes an interesting point.

do you mean the cell looks like

=Formula

so you see the formula instead of the result

or just that the formula doesn't recalculate when you change a value it is
dependent on.

 

[Guest]

the formula does not calculate, if I hit F2 & enter it works

 

[Tom Ogilvy]

select a single cell, all cells or the cells that are problematic and do

Edit=>Replace
Replace What: =
Replace With: =

 

[Tom Ogilvy]

Thanks for the sentiment, but
There would be too many typos and they would probably want Dave Peterson to
Review it. Yikes!

 

[Tom Ogilvy]

Oops, wrong thread - disregard.

 

[Gary Keramidas]

i'm glad i'm not the only one that does that<g>

 

[Dave Peterson]

This can't be good--'cause we know he doesn't open attachments!

 

[Guest]

Tom,

I had the same issue. This fix works. Thanks.

Any idea why it works and none of the methods to explicitly force
calculation work?


- Steve

 

[Guest]

I have multiple spreadsheets that when I type in a formula (i.e. =sum(k152/8)
and proceed to copy the formula into other cells - the value of k152 answer
is repeated into the cells even though the formula changed to i.e
=sum(k153/8).
I have updated all applicable Office 2003 updates etc. and I am still having
this problem, whether it's a new spreadsheet or existing one.
Please help!!!!!!!!!!!!!!!!!!