Thread: Disable Automatic Re-calculations and Adding a Button to do the Job

Hi,

I have a spreadsheet which plots a chart based on some input data and a number of calulations (functions) in a module. There is a lot of data and when you change an input value, the spread sheet takes a minute or so to re-do the the calculations and then re-plot the new chart. Could any one tell me how to do the following:

1. Stop excel from automatically re-calculating everything after each input change i.e. disable the automatic re-calculations so the user can make multiple input changes without waiting for re-calculations after each new input.

2. Add a button that allows you to perform the re-calculation once you have made multiple input changes.

Any help would be greatly appreciated.

Best Regards,

Aaron

could try some link this

Sub Macro1()

Calculate
With Application
.Calculation = xlManual
End With
End Sub

and attached it to a button.


but you need to click on Tools>OPTIONS>calculations>manual.