Manual Calculation doesn't prevent calculation on the first change?

[Cowsheepo]

Sorry if this has been answered before, I couldn't think of a search term that would answer my question.

Essentially, I have an input sheet and a very hefty calculation sheet. On opening the input sheet, and after calculating, calculation mode is set to manual.

After that, when I make a change to the input sheet, excel hangs and becomes not responding for around 10 seconds, as if it is calculating. After that the changes are instant and it doesn't hang.

Does anybody have any idea of how to stop it from doing this?

 

[Gingertrees]

There are many, many things that could cause a delay like you have described. Please post the code and maybe one of us can find the bottleneck.

 

[Cowsheepo]

I'm hesitant to send the spreadsheet since it's fairly confidential.

In the end, I just worked around the issue using Sheet.Range.CalculateRowMajorOrder so that no dependencies or anything was calculating, meaning it's nice and quick.