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,