Re: Is updating Excel cells from multiple threads a bad idea?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Tim,

No. They are not updating overlapping regions. Actually the updating works
unless somebody starts to click around in the work*** (no editing). Then
the update function will throw an exception.

Hans


> It perhaps not a good idea to allow both automatic *and* manual updates at
> the same time, even if you're only using a single thread.
> With multiple threads you might want to implement some kind of lock flag, so
> each thread will wait until the previous one has completed its work. Are
> the threads updating overlapping ranges?
>
> Tim
.

Quantcast