All Excel instances inaccessible due to long running macro

[michaeljc70]

I have a worksheet that contains a VBA that run a very long time
(hours). This keeps me from accessing unrelated worksheets as it seems
like Excel (even another instance) is tied up handling the first one.
Is there anyway to prevent this?

 

[Alan]

I have a worksheet that contains a VBA that run a very long time
(hours). This keeps me from accessing unrelated worksheets as it seems
like Excel (even another instance) is tied up handling the first one.
Is there anyway to prevent this?

Hi,

I have a workbook that does something similar.

However, I normally find that if it is run in a separate instance of
excel (truly independent process) then the two don't interact.

However, it does use up system resources and slows down the machine
running the code (as you would expect).

My own solution has been to run that process under Terminal Server on
our File & Print server avoiding the impact to my machine. However,
that may not be a solution for you.

HTH,

Alan.