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