Excel Slow after Running Code

[FallingDown]

Hi everyone

I need to regularly run the following code on my sheet to perform consistency checks.
However, after running this Excel really slows down, and I cannot really figure out why.

Please Login or Register  to view this content.

Any advice how to avoid that?

Thanks
FD

[CK76]

Doing error check by filter, forces Excel to recalculate everything. So, the calculation process is likely culprit in slowing down after the code.

I typically avoid filtering data with calculation in it, and use advanced filter copy or some other method to extract/check data.

Without seeing sample file hard to say for sure, what other factors are impacting workbook performance.

[FallingDown]

HI CK76

Thanks. I will look into that.
But I am wondering why the memory/performance is not released?

Cheers