I need to share a workbook between 8 people, I understand the process
of sharing the workbook, but what I need to know is:
If one user starts to insert information into one row (i.e. row 2) and
another user starts to do the same, how can I get the workbook to make
the information entered into two rows?
The worksheet is a list of all the ongoing work that our team does,
and because we are always receiving new work, the sheet will get
updated regularly which means that I need the above to be possible to
make sure that all new work is recorded in it's own row.
Is this possible at all?
Jim Gordon MVP - 27 Nov 2007 01:39 GMT
Hi,
Yes, this is already taken care of for you by Excel.
Use Tools > Share Workbook. Click the Advanced tab for additional options.
You can decide which changes "win" when you turn sharing on.
As a bonus, the people sharing the workbook can be both PC and Mac users
simultaneously. Excel is the only product that I know of that supports this
kind of sharing.
-Jim
Quoting from "designermonkey@hotmail.co.uk" <designermonkey@hotmail.co.uk>,
in article
33248472-acea-4393-94f5-101e8727ec3a@e23g2000prf.googlegroups.com, on [DATE:
> I need to share a workbook between 8 people, I understand the process
> of sharing the workbook, but what I need to know is:
[quoted text clipped - 9 lines]
>
> Is this possible at all?

Signature
Jim Gordon
Mac MVP
MVPs are not Microsoft Employees
MVP info http://mvp.support.microsoft.com/