Excel 2002 recalculation while executing VBA Procedure
I am running DDE real time data into sheet one, linking to a series of sheets
with fair amount of formulas. This still recalcualted reasonably OK though it
appears to be close to the edge.
If I now try to run a VBA procdure for more complex analysis the
recaluclation appears swamped and DDE also usually crashes.
Even a simple VBA function to show current tim ( TIMER$) give the dreaded
hourglass and stop the rest in its tracks (shows the right time though with
second ticks,,,,)
Any thought how I can run the VBAprocs without crashing the DDE incoming
stream nor the recalculation system as the data comes in.
Many thanks for any help.
Happy Easter,
Ed Leshik
|