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

Tools>options>calculation, set it to automatic?


--
Regards,

Peo Sjoblom



"Angela" <(E-Mail Removed)> wrote in message
news:3DC657D9-5C20-4186-8216-(E-Mail Removed)...
>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

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