Sharing Workbooks on a Network

It has always been possible to share Excel files on a network. You just had to make sure you coordinated your efforts to avoid having more than one person open a file at the same time. With recent versions of Excel, however, two or more people can work on the same workbook simultaneously. In Excel 2007, click the Review tab, and then click Share Workbook in the Changes group on the Ribbon to open the Share Workbook dialog box shown in Figure 24-3.

Select the Allow Changes By More Than One User At The Same Time check box to share the workbook.

Figure 24-3. Select the Allow Changes By More Than One User At The Same Time check box to share the workbook.

When you select the Allow Changes By More Than One User At The ...

Get Microsoft® Office Excel® 2007 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.