Hi everyone,

I was wondering if anyone can tell be a better way to do this. I am working
with financial information in Excel. I have roughly 50 locations and 5 years
history. The locations run done column A with the year in column B. I grouped
them so I only can see 2007 information, but and ungroup any location and see
the prior 5 years data.

What I'm finding is that when using the D-sum function to sum these
locations by year or region, that we I "expand" all of the groupings or close
them, Excel freezes up and it takes about 7 minutes for my program to respond.

I'm only working with about 3000 rows. Any suggestions, or does the D-sum
formula just bog down Excel?