Hi Ben,

Sounds to me like its taking time to crunch. Couple of things to look at
1 Is Calc set to Automatic. If it is set it to Manual, then use <SHIFT F9
to recalc the tab the data is in.
2 Have you looked at Array formulae. This may prove to be a quicker method

John

"Ben" wrote:

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?