If all you are interested in is the totals, then why not have a sheet that just contains the necessary totals without using the ".Range" command so the rows don't expand and collapse?
_________________________
Andrew Bates