Disable Automatic Calculation

[tejay]

Hi All,

I have some worksheets with a lot of functions, these functions only need to be updated once.
These functions come from VBA modules.

Even if I place;

Sub CalculationFalse()
ThisWorkbook.Sheets("Sheet Name").EnableCalculation = False
End Sub

In each particular sheet, it still takes a long time to calculate.

However if I copy and paste values in each sheet the file calculates quickly.

I am assuming from the "copy and paste values" test that calculations are still running on these sheets (or in the VBA modules??) despite the VBA code I have put in each sheet.

Can anyone help?

Thanks

[Pete_UK]

If you have used copy/paste values then the formulae are replaced by the actual values - there is no formula anymore, so there is nothing to calculate.

Hope this helps.

Pete

[tejay]

Hi Pete,

Sure but there are still formulas on other worksheets that are calculating.

So the VBA I tried to use above hasn't stopped the calculations on these sheets.

If it did, I presume it should calculate as quick as the version where I copied and pasted the values of these certain worksheets?

So the problem is - how do I force excel to completely ignore all calculations and macros on a particular worksheet. I note there are a ton of forum topics on this, but bugger me if I can get any to work.

Thanks

[tejay]

Anyone have any ideas how to solve this problem?
On selected sheets, I don't want excel to do or even think about doing a calculation.