O'Reilly logo

Microsoft® Excel® 2010 Inside Out by Mark Dodge and Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Sharing Workbooks on a Network

image with no caption

It has always been possible to share Excel files on a network. You just had to be 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 2010, 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 25-3.

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

Figure 25-3. Select the Allow Changes By More Than One User At The Same Time ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required