Sharing Workbooks

When you’re working with others in a networked environment, you may want to share workbooks you have created. You may also want to share the responsibilities of entering and maintaining data. Sharing means users can add columns and rows, enter data, and change formatting, while allowing you to review their changes. When sharing is enabled, “[Shared]” appears in the title bar of the shared workbook. This type of work arrangement is particularly effective in team situations where multiple users have joint responsibility for data within a single workbook. In cases where multiple users modify the same cells, Excel can keep track of changes, and you can accept or reject them at a later date.

Enable Workbook Sharing

Open the workbook ...

Get Excel® 2013 On Demand 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.