Excel take longer to execute after each run

[Đậu Đình Hùng]

I got an error with my DNA addin.
If I run the code more than once, my code will take longer to execute after each run.
I freed the variables of the object type by assigning null values ​​to it.
But the situation is still not improving.
If I close the workbook and then reopen it, the execution speed is fast again.
Can someone tell me the cause and a good solution?

Thank you.

[Govert van Drimmelen]

Can you make a small, self-contained example that shows the problem?

Then I could try to see what is happening.

-Govery

--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/exceldna/5f52c2ae-2f26-4331-aa04-6d3eb85089adn%40googlegroups.com.

[AE]

I am also seeing similar behaviour in my application. This is not consistent. Sometimes a worksheet may take 10 seconds to refresh, but with each consequent refresh it takes a few seconds longer. So after 10 refreshes, the sheet may take over 30 seconds to refresh.