Chapter 2. Share Workspaces and Lists

If you've ever tried to collaborate on a budget, project bid, or other team-oriented workbook in Excel, you know that just putting the .xls file up on a public server somewhere doesn't cut it. Only one person can edit the workbook at a time, and if somebody leaves the file open, the rest of the team is locked out till you find out who the culprit is and get him to close his session.

Earlier versions of Excel solved this problem with shared workbooks , which let more than one user have a single workbook open for editing. Changes are merged automatically, and conflicting changes can be resolved. That's great, but it's a file-based system, so there is no way to manage the document's users, notify teammates of changes, assign tasks, or do other team-oriented work.

Microsoft Excel 2003 finally solves these problems with shared workspaces and shared lists . This solution is server-based (Windows 2003 server-based, in fact) and integrated right into the Excel menus and object model.