Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a multi-user spreadsheet
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a multi-user spreadsheet
Steve wrote:
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. -- Andy B |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a multi-user spreadsheet
Thanks - but for a realtime update system - is there any other method other
than this and that offer by the "Bad Blue" Company ? Steve "Andy B" wrote in message ... Steve wrote: 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. -- Andy B |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a multi-user spreadsheet
"Steve" wrote ...
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. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating multi-user Excel form for online | Excel Discussion (Misc queries) | |||
Multi-user | Excel Discussion (Misc queries) | |||
multi user | Excel Discussion (Misc queries) | |||
Multi user | Excel Discussion (Misc queries) | |||
How to make it a Concurrent (Multi-user) spreadsheet | Excel Programming |