Creating a multi-user spreadsheet

[Steve]

Hi,

Does Excel have any facilities through which I can create a realtime shared
spreadsheet - such that if one user updates a cell, or a row all others see
that update & vice-versa ? Sadly not an application for a database due to
the analytics involved, though perhaps a combination if such a thing is
possible ?

Any pointers would be welcome.


Steve

 

[Andy B]

Hi,

Does Excel have any facilities through which I can create a realtime
shared spreadsheet - such that if one user updates a cell, or a row
all others see that update & vice-versa ? Sadly not an application
for a database due to the analytics involved, though perhaps a
combination if such a thing is possible ?

Any pointers would be welcome.


Steve

Shared workbooks. Go to tools menu. Though the user needs to save his
changes for others to see an update.

 

[Steve]

Thanks - but for a realtime update system - is there any other method other
than this and that offer by the
"Bad Blue" Company ?

Steve

 

[Jamie Collins]

Sadly not an application for a database due to
the analytics involved, though perhaps a combination if such a thing is
possible ?

Databases are optimized for data storage and retrieval but are
mediocre for analysis work. Excel is an excellent for analysis but is
mediocre when it comes to data storage and retrieval (limited rows per
table, poor data typing, lack of DRI constraints etc).

Using Excel and a 'proper' database product should yield the best of
both. The preferred data access tools for Excel are ADO in VBA code
and MS Query for GUI tools.

Jamie.

--