Excel VSTO Asynchronous call

Question

Hi,

In my C# implementation, I have imported macro to create query connection then add new pivot from there.
However, when it is triggered and if I have multiple workbooks opened, all of them will be under busy state.

Is there anyway to make other workbooks available to use while the pivot generation is in progress?
I don't want other workbooks to be under busy state, only the one with pivot generation should be busy (freeze).

Thanks.