View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ed Leshik[_2_] Ed Leshik[_2_] is offline
external usenet poster
 
Posts: 2
Default 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