Excel VBA Sheet EnableCalculation Working Intermitently : I am working on a spreadsheet for my company and I am having trouble with the EnableCalculation function. We copy large chunks of data and paste them into a workbook. To expedite this process, I 'freeze' sheets by turning the EnableCalculation to False as shown in the example ([Disabled][1]). Without  this, Excel slows to a crawl while background calculations are done as the data is being pasted.

In the macro that does the calculation for this workbook once all the data has been pasted, I re-enable the calculation by setting EnableCalculation to True. ([Re-Enabled][2]) The issue that I have found, however, is that sometimes the sheets calculate properly but other times they do not with seemingly no rhyme or reason. It is extremely frustrating for it to be so unpredictable. Is there a way to ensure that the sheets calculate when they are supposed to? Thanks, 


  [1]: https://i.stack.imgur.com/uvV2d.png
  [2]: https://i.stack.imgur.com/hJ22l.png