Formulas not working

  • Thread starter Thread starter John Lovin
  • Start date Start date
J

John Lovin

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
 
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

If you're wondering how it got switched to "manual"......

Excel takes the Calculation mode each session from the settings on the first
workbook opened in that session.

i.e. If you saved Book1 with calc mode in manual and opened it first, calc
mode would be in Manual.

If you saved Book2 with calc mode in auto and opened it after Book1, Book2
would be in manual mode(Excel ignores the auto calc mode in this case).

If you close Book1 before opening Book2, Book2 will be in auto calc mode.

Confusing enough? <g>

NOTE: if you are loading Personal.xls and its settings are at "manual",
change this to "Automatic" and re-save Personal.xls.

Gord Dibben Excel MVP
 
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 said:
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 said:
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
Click to expand...
Click to expand...
 
John

The [group] means you have more than one worksheet selected.

This will not affect calculation setting, but can cause disastrous effects on
the sheets in the group.

What you are entering/formatting on one sheet will be done to all sheets in
the group.

You will notice two or more sheet tabs are colored white. These are the
sheets that are grouped.

Select an ungrouped sheet or right-click on any sheet and "ungroup sheets".

Depending upon how long you have had the sheets grouped, you could have
some(many?) errors on these sheets.

Check carefully before ungrouping.


Gord Dibben Excel MVP

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 said:
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
Click to expand...
Click to expand...
 
Gord,

I figured it out...thanks...Geeze...I've not EVER had this much trouble!
Thanks for the help.

John

Gord Dibben said:
John

The [group] means you have more than one worksheet selected.

This will not affect calculation setting, but can cause disastrous effects on
the sheets in the group.

What you are entering/formatting on one sheet will be done to all sheets in
the group.

You will notice two or more sheet tabs are colored white. These are the
sheets that are grouped.

Select an ungrouped sheet or right-click on any sheet and "ungroup sheets".

Depending upon how long you have had the sheets grouped, you could have
some(many?) errors on these sheets.

Check carefully before ungrouping.


Gord Dibben Excel MVP

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 said:
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

I've never had this before. I track information on a weekly basis
Click to expand...
and
the
worksheet uses formulas (obviously). I've been just opening the
spreadsheet
and entering new data and the formulas recalculate. This week, when
Click to expand...
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
Click to expand...
Click to expand...
Click to expand...
 
Hi John,
Hope you take backups, just in case things get worse
or turn out to be worse than you thought.
http://www.mvps.org/dmcritchie/excel/backup.htm


John Lovin said:
Gord,

I figured it out...thanks...Geeze...I've not EVER had this much trouble!
Thanks for the help.

John

Gord Dibben said:
John

The [group] means you have more than one worksheet selected.

This will not affect calculation setting, but can cause disastrous effects on
the sheets in the group.

What you are entering/formatting on one sheet will be done to all sheets in
the group.

You will notice two or more sheet tabs are colored white. These are the
sheets that are grouped.

Select an ungrouped sheet or right-click on any sheet and "ungroup sheets".

Depending upon how long you have had the sheets grouped, you could have
some(many?) errors on these sheets.

Check carefully before ungrouping.


Gord Dibben Excel MVP

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

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

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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top