shared workbook questions

[designermonkey]

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]

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 "(e-mail address removed)" <[email protected]>,

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
Mac MVP

MVPs are not Microsoft Employees
MVP info