Excel won't calculate
 

I have a spreadsheet that originally worked with the formulas using basic SUM
and IFSUM. I have posted it to my web site, with protection and only left
certain cells open for editing. I recently discoverd that it is no longer
calculating. I have opened it, removed all protection, unlocked all cells
and redone some of the SUM calcs, but it still won't calc when I change the
values in the cells that are in the SUM range.

Years ago, Excel had problem if you copied the formulas too many times, it
stopped recalculating, but I am not sure what the issue with this sheet is.

I have even run the formula evaluation. When I change a single value in the
column from 0 to 1 and evaluate, the SUM still appears as 0.

Help!!!

Excel won't calculate
 

Just to get one of the dumb things out of the way: Have you checked under
Tools, Options, Calculation to make sure it hasn't somehow been changed to
Manual?

--- "davem97132" wrote:
I have a spreadsheet that originally worked with the formulas using basic SUM
and IFSUM. I have posted it to my web site, with protection and only left
certain cells open for editing. I recently discoverd that it is no longer
calculating. I have opened it, removed all protection, unlocked all cells
and redone some of the SUM calcs, but it still won't calc when I change the
values in the cells that are in the SUM range.

Years ago, Excel had problem if you copied the formulas too many times, it
stopped recalculating, but I am not sure what the issue with this sheet is.

I have even run the formula evaluation. When I change a single value in the
column from 0 to 1 and evaluate, the SUM still appears as 0.

Help!!!

Excel won't calculate
 

Bob,

Thanks. Do you have any idea how that got converted over from being auto to
manual? Anything that can prevent that from happening again? Thx.

"Bob Bridges" wrote:

Just to get one of the dumb things out of the way: Have you checked under
Tools, Options, Calculation to make sure it hasn't somehow been changed to
Manual?

--- "davem97132" wrote:
I have a spreadsheet that originally worked with the formulas using basic SUM
and IFSUM. I have posted it to my web site, with protection and only left
certain cells open for editing. I recently discoverd that it is no longer
calculating. I have opened it, removed all protection, unlocked all cells
and redone some of the SUM calcs, but it still won't calc when I change the
values in the cells that are in the SUM range.

Years ago, Excel had problem if you copied the formulas too many times, it
stopped recalculating, but I am not sure what the issue with this sheet is.

I have even run the formula evaluation. When I change a single value in the
column from 0 to 1 and evaluate, the SUM still appears as 0.

Help!!!

Excel won't calculate
 

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

BTW.........not yet updated in 2007 version.

To prevent, make sure you first open a workbook with calculation set to Auto or
include setting to austo in your workbook_open code.

With Application
.Calculation = xlAutomatic
.anything else you need
End With


Gord Dibben MS Excel MVP

On Wed, 4 Jun 2008 17:11:01 -0700, davem97132
wrote:

Bob,

Thanks. Do you have any idea how that got converted over from being auto to
manual? Anything that can prevent that from happening again? Thx.

"Bob Bridges" wrote:

Just to get one of the dumb things out of the way: Have you checked under
Tools, Options, Calculation to make sure it hasn't somehow been changed to
Manual?

--- "davem97132" wrote:
I have a spreadsheet that originally worked with the formulas using basic SUM
and IFSUM. I have posted it to my web site, with protection and only left
certain cells open for editing. I recently discoverd that it is no longer
calculating. I have opened it, removed all protection, unlocked all cells
and redone some of the SUM calcs, but it still won't calc when I change the
values in the cells that are in the SUM range.

Years ago, Excel had problem if you copied the formulas too many times, it
stopped recalculating, but I am not sure what the issue with this sheet is.

I have even run the formula evaluation. When I change a single value in the
column from 0 to 1 and evaluate, the SUM still appears as 0.

Help!!!

Excel won't calculate
 

My office 2007 Excel started doing this as well. If you need to fix it in
the 2007 version:

Click the Microsoft Office Button (that colorful swirly flower thing in the
upper Left corner) , click Excel Options (at the bottom right), and then
click the Formulas category. Under Calculations Options - Workbook
Calculation select "Automatic"


"Gord Dibben" wrote:

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

BTW.........not yet updated in 2007 version.

To prevent, make sure you first open a workbook with calculation set to Auto or
include setting to austo in your workbook_open code.

With Application
.Calculation = xlAutomatic
.anything else you need
End With


Gord Dibben MS Excel MVP

On Wed, 4 Jun 2008 17:11:01 -0700, davem97132
wrote:

Bob,

Thanks. Do you have any idea how that got converted over from being auto to
manual? Anything that can prevent that from happening again? Thx.

"Bob Bridges" wrote:

Just to get one of the dumb things out of the way: Have you checked under
Tools, Options, Calculation to make sure it hasn't somehow been changed to
Manual?

--- "davem97132" wrote:
I have a spreadsheet that originally worked with the formulas using basic SUM
and IFSUM. I have posted it to my web site, with protection and only left
certain cells open for editing. I recently discoverd that it is no longer
calculating. I have opened it, removed all protection, unlocked all cells
and redone some of the SUM calcs, but it still won't calc when I change the
values in the cells that are in the SUM range.

Years ago, Excel had problem if you copied the formulas too many times, it
stopped recalculating, but I am not sure what the issue with this sheet is.

I have even run the formula evaluation. When I change a single value in the
column from 0 to 1 and evaluate, the SUM still appears as 0.

Help!!!