To slow down calculations on row by row basis

[netguru]

Hi,

I have a spread sheet that extracts data from a server and performs calculation.

Example.

Data	Calculation
1	a
2	b
3	c

If there are only a few rows, the spreadsheet works fine.
But If there are many rows eg. hundreds, the server will be locked up for about 30 mins due to many queries coming in together at one time.

So I am asking if there is a way to make the spreadsheet to do its stuff row by row with an interval of say 5 seconds?

Thank you.

Best Regards,

[netguru]

Hi,

Any advise please? I am a newbie on VBA but I was reading through and it seems that a wait command or time delay command will help.

I am also willing to pay a small fee for a working solution.

Please advise.