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

Excel 2002 recalculation while executing VBA Procedure
 

Stop the simple timer function?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ed Leshik" wrote in message
...
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