Sharing Your Workbooks with Your Colleagues

You may create some workbooks on your own, but for others, you'll probably need to work with colleagues to collect, enter, and analyze data. You can either share a workbook on the network so that one person can work on it at a timeor turn on Excel's sharing features that enable you and your colleagues to work on the workbook at the same time.

Before sharing a workbook, you may choose to protect it with a passwordor to allow your colleagues to make only some types of changes to it.

Protecting a Workbook or Some of Its Worksheets

Before sharing a workbook with your colleagues for editing individually on a network, you may want to restrict the changes your colleagues can make in the workbook or on some ...

Get Learn Excel 2011 for Mac now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.