Triggers from Excel in running

[ddaann]

I use various triggers fired from Excel in running, and I'm looking for ways to make them faster.
I have refresh rate set to 0.1 seconds and refresh rate I get is 80-150ms.
I have PC with Celeron 2.66 Ghz and 1GB RAM, Windows XP and Excel 2003, 18 Meg broadband with pings around 50-60 ms.
Since in running every milisecond counts, I'd like to hear your suggestions how to make those triggers fire faster.
I tried using Office 2007 but it seems it is slower than 2003. Also I believe XP is much faster on lower memory than Vista.
I dont use any VB / macros in my spreadsheets, I believe that will only slow them down, is this true?
I'm thinking about getting new PC, do you think that dual processor will make much difference in speed?

[bolpx001]

Office 2007 is designed to run on a Vista machine running a dual core processor with a fair chunk of memory and although it will run on less, there is really no point. I haven't tried it on Vista but I am told it is much faster
Paul

[dgs2001]

Hey Dejanuk

I am confused by the idea that VB would slow down your sheet, I don't know but I thought VB was faster than just sheet formulas?

If you lift the formulas off the sheet and only have the code running in memory then there is no graphics to update on the screen.

I would imagine this would make a difference.

I'm sure someone will tell me if I'm talking B**locks.

Duncan

[PeteB]

It depends how you write your macros - every time you interact with a cell that means a COM call, which is slow. Also if you do things like .Activate() then you are making graphical things happen too, which is very slow.

If you do one operation to copy a range of data into code, do all you work in code, and then do one operation to put everything back in the sheet (e.g. you can set trigger odds and stake with a single call rather than 3 separate calls) then it should be much faster than cell formulae