I have a worksheet with about 55000 rows and 15 columns --10 of which contain formulas in nearly every row. When I open the workbook up with the Automatic calculation enabled, it Calculates on the status bar rather quickly: maybe a few seconds.
At the bottom of the worksheet I need three rows: total, count, and average. When I try to AutoFill the total (SUM) and count (COUNT) formulas across the columns, everything works fine. But when I try to do the average and AutoFill (using either AVERAGE or SUBTOTAL), the status bar reads "Calculating 0%" and Excel locks up (stops responding). Also, if I try to copy an AVERAGE cell and then paste it, Excel locks up.
Of course, if I set the Calculation to Manual, everything works fine. But my question is, why did I have no problems until I tried to calculate an average?
Another question: Will changing the Iterations make any difference?
Thanks for any help with this issue.