You are here LEARN EXCEL & VBA Excel Tips Excel Text, Editing and Format Sharing and Allow Users to Edit Changes in Excel 2007

Sharing and Allow Users to Edit Changes in Excel 2007

To share a workbook with other users:

1. Select Review -> Share Workbook (in Changes Group).
2. Select Allow changes…and click OK.



To protect sharing:

Select Review -> Protect Sharing (in Changes Group).

To allow users to edit ranges:

Select Review -> Allow Users to Edit Changes (in Changes Group).



To track changes:

Select Review -> Track Changes (in Changes Group) -> Highlight Changes.