Creating a multi-user spreadsheet

S

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
 
A

Andy B

Steve said:
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
Click to expand...


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

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
 
J

Jamie Collins

Steve said:
Sadly not an application for a database due to
the analytics involved, though perhaps a combination if such a thing is
possible ?
Click to expand...

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.

--
 
Top