On 2ÔÂ13ÈÕ, ÏÂÎç10ʱ48·Ö, "RB Smissaert"
wrote:
Have a look at posting number 7 in this thread:http://groups.google.co.uk/group/mic....programming/b...

RBS

wrote in message

...
On 2ÔÂ13ÈÕ, ÏÂÎç3ʱ09·Ö, "Arvi Laanemets" wrote:





Hi

It's possible to several users open same Excel workbook simultaneously,
but
only the first user has write rihgt. When he/she closes the file, the next
user gets write right, etc.

To overcome this you can give every user his/her own workbook. You have to
design those workbooks in such a way, that any kind of information may be
entered or modified only by certain user. The information entered by other
users may be only displayed. To display the information from other
workbooks, you use link formulas (like ='C:\Documents and
Settings\YourProfile\My Documents\[YourFile.xls]SheetName'!A1), or you
import needed data from other workbook(s), using ODBC querie(s), to
special
(hidden) sheets and refer to these query tables to get data into working
sheets.

Both ways don't interfere with user working with his/her data. But either
of
the ways doesn't reflect changes done by other users immediately. I myself
design such file systems so, that data are refreshed when the file is
opened.

--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )

wrote in message

...

Is it possible to make a worksheet auto tracking the data from other
worksheet in the server? a little bit like making an excel
database,however, i thought that excel data sheet cannot enable multi-
access. Is it possible to overcome this problem?- Òþ²Ø±»ÒýÓÃÎÄ×Ö -

- ÏÔʾÒýÓõÄÎÄ×Ö -

Where can i find those materials taught about ODBC query apply to
excel sheet? I'd like to try the way import needed data using ODBC
queries.Thank you- Òþ²Ø±»ÒýÓÃÎÄ×Ö -

- ÏÔʾÒýÓõÄÎÄ×Ö -

Thank you Arvi, i'll try to do it and will ask you again if any
problem occured.
Thank you very much.