EXACTLY PUTTING IT TECHNICALLY
While linking the excel sheet in DAO(data control) and display in DBGrid, I can see the sheet. But when make updation in the excel sheet , it has to be updated in the grid view. There is about 2 seconds time delay to make updation.

How to do this without timedelay only a few micro seconds instead of in seconds. Or in other words the correction has to be taken in the DBand view simultaneously.

How to avoid the time delay? That is the problem to be resolved

the dbgrid is placed in vb form and it is linked through dao control
(
data control) ie. i am accessing the excel file from vb applications (
not
in excell application ).

- i have saved the file in the server - ie. accessing the excel file
from
server to my vb applications.

- the file is size is may be around 500 to 600 kb only ( max in. 2 mb
)

- while updating the excel file the updations carried out in vb
application
grid display has taken some tike delay in seconds.

shifting online data as per formula with very minimum timelag


the dbgrid is placed in vb form and it is linked through dao control
(
data control) ie. i am accessing the excel file from vb applications (
not
in excell application ).

- i have saved the file in the server - ie. accessing the excel file
from
server to my vb applications.

- the file is size is may be around 500 to 600 kb only ( max in. 2 mb
)

- while updating the excel file the updations carried out in vb
application
grid display has taken some tike delay in seconds.




PUTTING IT FOR MORE CLARITY OF THE PROBLEM
i have one excel sheet, one particular column datas are varying by some other controls. There may be a variation for 5 to 10 seconds in the data . From that variations I have to find the minimum reading in particular column and maximum reading and current reading also.

I will put this same question in another format also again ::
In excel sheet a column contains 150 cells and in each cell the data changes 2 to 30 times per second. We have to find out the maximum value, minimum value and current value of that fluctuating data from each cell and put it separately in adjacent columns(cells). Please note that each cell is independent and there should not be any time delay in this calculations because data flows online from a server. So each cell data should be monitored independently updated instantly for their minimum and maximum and current values in nearby cells with out time delay. Here the problem to be solved is how to avoid the time delay is the main question. Point to be noted is there are about 150 cells and each cell has no connection in the data with other cell. Each cell is totally independent and the online data flowing in each cell has no connection to the other cell and each cells online data should be updated instantly without time delay for their minimum, maximum, and current values in the adjacent cells. I could do this with time delay of 1 to 2 seconds, but the problem to be solved is how to minimise the time delay to the maximum or avoid the time delay totally.