Excel 2002 recalculation while executing VBA Procedure

[Guest]

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

 

[Bob Phillips]

Stop the simple timer function?

--

HTH

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