John,

I think you were on the right track with the Tool | Options | Calculations
setting being on Manual. Make sure this is set to Automatic and save the
file immediately afterwards.

Something that I've noticed that happens with the calculation setting is
that if I have a spreadsheet open that is set to Manual Recalculation and
then open one at the same time, that should recalculate Automatically,
because the first spreadsheet was set to manual, the second one gets changed
without my knowledge. Maybe that happened to you?

Henry Falk

"John Lovin" wrote:

Ok. I thought I'd figured it out. When I open the file, in the Title Bar,
it has the file name followed by the word [Group] and the formulas are still
screwed up.

Help!

John

"John Lovin" wrote in message
...
Ok. This is strange. I just figured out what the problem is with the
recalculation, but don't know what caused it. In the
<Tools<Options<Calculation Menu, Calculation was set to Manual. Do any
of you know how this could happen? Some sort of inadvertant hot key
combo?
Virus?

Thanks,

John

"John Lovin" wrote in message
...
I've never had this before. I track information on a weekly basis and
the
worksheet uses formulas (obviously). I've been just opening the
spreadsheet
and entering new data and the formulas recalculate. This week, when I
put
the new data in, the totals in the cells with the formulas didn't
update.
The formula is correct =C6+D6 or whatever), but no recalculation.

Any suggestions?

Thanks in advance.

John Lovin