Posted by Mark on April 30, 2001 2:50 PM
I have a large table of rows that have been subtotalled with the data / subtotal feature. Suddenly in tier 2 mode, they are reporting zero. In tier 3 (expanded mode) they report normal subtotals of positive values. The formula in the subtotals isn't changing between shrunken and exploded.
Did I mess with the options of this spreadsheet? Calculation is set to automatic and a manual F9 won't change the zero results of my shrunken table...
Hope you can help!