memory-friendly summing of dynamic columns?

[miconian]

Hello,

I have a 'data' worksheet full of raw data, including one column, let's say column AE, that is the 'net amount' column. For various reasons, I need to keep a running total of this column displayed on another worksheet. So far I have been doing this with the formula:

=SUM(Data!AE:AE)

However, the workbook calculations have slowed to a snail's pace, and I've read that calculating entire columns in Excel 2007 (which I use) can be a cause of this.

The problem is that the number of rows of data in the Data worksheet, and therefore in column AE, changes every week. I'm not sure what the best way to handle this is. Given multiple choices, I would prefer the option that will slow down Excel the least.

Other possibly relevant info: all the data on the Data worksheet comprises an Excel Table (formerly known as List, as I understand it), with the name EstimatesData.

Thanks!

 

[Andrew Poulsom]

I think Excel is clever enough to ignore the cells below your data, but you can use structured references with a table:

http://office.microsoft.com/en-us/e...references-with-excel-tables-HA010155686.aspx

 

[miconian]

Thanks, I have put that into use. It seems to have speeded up calculation, but perhaps that's just my imagination.