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