You have something else going on.

If you are talking about the 4 meg workbook Sales 10_2009.xls you sent me,
When I change a bunch of cells in A140:A60 in Prev Month sheet, it takes a
blink of the eye for the 31 sheets to change.

If some other workbook email to me and I'll have another look.


Gord


On Tue, 6 Oct 2009 21:21:59 -0300, "Ed Davis"
wrote:

After adding this line of code it is taking about 4 to 5 seconds to
calculate each cell I change.
With over 300 cells at a time it would take forever to calculate the whole
sheet.