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 ...