Simple Question on Calculations

[ercedwards]

I have a workbook with 20 worksheets in it.

There are some 100,000 cells in total that contain calculations.

During data input I turn calculation mode to Manual otherwise these calcs are running flat out all the time that data is entered and thiungs run really slowly.

Once a line of data input is completed, a macro turns calc back to Automatic and then back to Manual for the next line of input.

Any line of data input only really affects perhaps 250 actual cells depending on which inventory item is being ordered.

Does anyone know of a way to keep calc in Automatic mode in a way that Excel only does calculations in the actual affected cells?

Thanks for any suggestions.

 

[mikerickson]

Avoid volatile functions like OFFSET or INDIRECT or NOW or TODAY