DDE real time and time dispay conflict

[Ed Leshik]

I am pulling real time stock (10 stocks)data into sheet1 andlinking each
stockto its own sheet on which I have a number of analytics in XL function
which updae as the data streams in.

I would like to use VBA procedures to increase the power of the analytics
but when I run any of these procedures it blocks the standard recalculation.

I have the same problem running a simple real time timedisplay
into a cell in one sheet.

Does this mean that when a VBA procedure runs there is nothing else that can
be done?

What if I use two instances of Excel and use one for DDE and link to the
other one where the Excel formulas are.

I have plenty of RAM but is there an intrinsic limit of how many instances I
can have running?

Many thanks of any help.

 

[Tom Ogilvy]

Easiest would be to test it out. I don't think there is an intrinsic limit
since some people that screw up their automation code have many instances
running.