Excel Processing Slowdown: Double-Click / Double Enter Bandaid

[Bill Bisco]

I'm using a spreadsheet that has a lot of Volatile formulas and arrays. As a result, typing anything into a cell will result in a cell processing wait of about 8 seconds. However, clicking twice, or pressing enter twice, etc. will shortcut the processing and display the cell content.

I'm advocating this be our organization until we can convert some of these spreadsheet operations to VBA.

Has anyone else adopted this same Double-Click / Double Enter Bandaid approach to long cell processing times?

Thanks,

Bill

 

[starl]

What you're doing is interrupting the calculation process, so some cells may return erroneous/out dated results.
If you really don't care if the workbook is 100% up to date, put the calculations on manual. Only those cells relevant to the one you modify should update (I believe.. there are some intricacies to calculation updating that I'm not particularly strong on).

 

[RCBricker]

Starl is correct. I would suggest changing your formula calculation option to manual. Then when you are done updating cells just hit F9. This is by far better than double clicking to interrupt the calculation, as you will know that no dependent formulas have been updated, whereas using the double click method one does not know how far along the dependency tree the calculation has gotten.

HTH