Sharing a Workbook

  • Thread starter Thread starter Abacus
  • Start date Start date
A

Abacus

We are running Excel 2003 on various XP computers on a peer-to-peer network.
We do not have Windows 2003 server or sharepoint.

So:

- How do we set up an Excel workbook so that two people can work on it at
the same time?

- Do we need Sharepoint, and if so can we install Sharepoint on an XP PC
without having a Windows 2003 server?

Thanks in advance.

Robert
 
Abacus,

You can set up a workbook as shared, within Excel. I'm not sure how solid it is -- there
have been some issues raised here and there. It lets multiple users open the same workbook,
make changes, and all changes get saved. Any conflicting changes (changes to the same cell)
must be resolved when the second saver attempts the save. Each user sees the workbook as it
existed when opened -- you don't see other user's changes. Many things are disallowed in
this mode. Tools - Share workbook.
 
Thanks Earl, I'll have a play with it.

Robert

Earl Kiosterud said:
Abacus,

You can set up a workbook as shared, within Excel. I'm not sure how solid
it is -- there have been some issues raised here and there. It lets
multiple users open the same workbook, make changes, and all changes get
saved. Any conflicting changes (changes to the same cell) must be
resolved when the second saver attempts the save. Each user sees the
workbook as it existed when opened -- you don't see other user's changes.
Many things are disallowed in this mode. Tools - Share workbook.
Click to expand...
 
Back
Top