View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default formulas not calculating

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

--


Gary


"Tom Ogilvy" wrote in message
...
Oops, wrong thread - disregard.

--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
Thanks for the sentiment, but
There would be too many typos and they would probably want Dave Peterson

to
Review it. Yikes!

--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote in message
...
select a single cell, all cells or the cells that are problematic and
do

Edit=Replace
Replace What: =
Replace With: =

--
Regards,
Tom Ogilvy

"Wade" wrote in message
...
the formula does not calculate, if I hit F2 & enter it works


"Tom Ogilvy" wrote:

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.

--
Regards,
Tom Ogilvy


"Wade" wrote in message
...
Sorry Tom, That does not work

"Tom Ogilvy" wrote:

How about
Ctrl+shift+F9

--
Regards,
Tom Ogilvy

"Wade" wrote in message
...
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.