You are here KNOWLEDGE Excel Tips Excel Text, Editing and Format Sharing and Allow Users to Edit Changes in Excel 2007

Query, Share and Manage Excel workbooks on LAN, Internet

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.