Multi user in Excel

[Tim Miller]

I have Office 97 at work, and whenever someone esle is in the Excel Workbook
that I need to edit, is there a way that more than one user can be in the
same workbook at the same time and be able to add their own data at the same
time? What I would like to do is to make a "Production Report" that when a
procedure is completed, the person at that workstation could type in their
initials and the front office could track just where in the production
process the customer's order is without having to go to the shop and
physically track the item with the customer on hold on the phone. Any
suggestions would be greatly appreciated.

 

[xyz]

Tim Miller wrote...
. . . is there a way that more than one user can be in the
same workbook at the same time and be able to add their own
data at the same time?

...

Shared workbooks are your only option

 

[Arvi Laanemets]

Hi

From my experience with shared workbooks, another users can open the
workbook when someone opened it before, but they aren't allowed to change
anything, until the first user has finished. For cases where different users
don't need to change same records (all records are user-specific), I prefer
the design, where users (or user groups, preferably the ones using the same
computer) all have their own private workbooks, and all summary info is
consolidated into summary workbook through links (you can add additional
info into workbook, but the info from source workbooks is to read only).

When the are too much of different users, or they may need to work with
same data (record) simultaneously, you have to consider using p.e. Access
instead of Excel

 

[Earl Kiosterud]

If you've designated the workbook as shared (Tools - Protect and share
workbook in XL2002), multiple users may have the workbook open concurrently,
make changes, and save whenever they want. The users don't see each other's
changes, and if two users change the same cell to different stuff, the
second one to save gets a conflict message, and is prompted for which data
to put in the cell, his, or the other person's.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Hi

From my experience with shared workbooks, another users can open the
workbook when someone opened it before, but they aren't allowed to change
anything, until the first user has finished. For cases where different users
don't need to change same records (all records are user-specific), I prefer
the design, where users (or user groups, preferably the ones using the same
computer) all have their own private workbooks, and all summary info is
consolidated into summary workbook through links (you can add additional
info into workbook, but the info from source workbooks is to read only).

When the are too much of different users, or they may need to work with
same data (record) simultaneously, you have to consider using p.e. Access
instead of Excel

 

[Arvi Laanemets]

Hi

Haven't get further as Excel2000 jet

 

[Earl Kiosterud]

Arvi,

In XL97, it's Tools, Protection, Protect and share workbook. I don't know
if XL2000 is the same, but it's there somewhere.

Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

 

[Peo Sjoblom]

Same in 2002 and 2003 as well