Bizarre Excel 03 Problem - autosum not updating when cells are cha
 

I have a workbook with about 125 tabs/sheets - each tab/sheet with several
columns that are summarized at the bottom, and then those summarized numbers
are linked to a main "summary" page. I noticed today that when I changed
numbers in any of the columns in any of the sheets, the autosummed total at
the end of the column did not change. I checked the formula in several
different columns, and they are all right, it's just not updating. I
re-entered the autosum formulas, and then it would calculate the right
numbers, but if I changed it again, it would again, not update. Also, none
of the sums of the columns are updating to the main summary page, even though
those formulas are correct too. This problem is throughout every sum and link
in the entire workbook. Does anyone out there know the fix for this? I have
looked and looked, and am completely stumped. Thanks in advance for any
suggestions.
-Angela

Bizarre Excel 03 Problem - autosum not updating when cells are cha
 

Toolsoptionscalculation, set it to automatic?


--
Regards,

Peo Sjoblom



"Angela" wrote in message
...
I have a workbook with about 125 tabs/sheets - each tab/sheet with several
columns that are summarized at the bottom, and then those summarized
numbers
are linked to a main "summary" page. I noticed today that when I changed
numbers in any of the columns in any of the sheets, the autosummed total
at
the end of the column did not change. I checked the formula in several
different columns, and they are all right, it's just not updating. I
re-entered the autosum formulas, and then it would calculate the right
numbers, but if I changed it again, it would again, not update. Also,
none
of the sums of the columns are updating to the main summary page, even
though
those formulas are correct too. This problem is throughout every sum and
link
in the entire workbook. Does anyone out there know the fix for this? I
have
looked and looked, and am completely stumped. Thanks in advance for any
suggestions.
-Angela

Bizarre Excel 03 Problem - autosum not updating when cells are cha
 

Tools|options|calculation
Set it to automatic?


"Angela" wrote:

I have a workbook with about 125 tabs/sheets - each tab/sheet with several
columns that are summarized at the bottom, and then those summarized numbers
are linked to a main "summary" page. I noticed today that when I changed
numbers in any of the columns in any of the sheets, the autosummed total at
the end of the column did not change. I checked the formula in several
different columns, and they are all right, it's just not updating. I
re-entered the autosum formulas, and then it would calculate the right
numbers, but if I changed it again, it would again, not update. Also, none
of the sums of the columns are updating to the main summary page, even though
those formulas are correct too. This problem is throughout every sum and link
in the entire workbook. Does anyone out there know the fix for this? I have
looked and looked, and am completely stumped. Thanks in advance for any
suggestions.
-Angela