Slow or long running functions that block Excel create a poor user experience.
This video covers a couple of ways to make your long running functions non-blocking so that your spreadsheets remain responsive while the function completes in the background.
Before starting with this tutorial we recommend that you have already installed PyXLL and are familiar with the basics of writing your own worksheet functions.
Also see Asynchronous Functions and Real Time Data in the user guide.
The contents of this video and accompanying code can be found in the blog post Long Running Excel Functions.