Change Sharing Options : Workbook Sharing « Workbook Worksheet « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Workbook Worksheet
  3. Workbook Sharing
Click the Review tab. 
           Then click the Share Workbook button.
Click the Review tab. Then click the Share Workbook button.
Click the Advanced tab.
Click the Advanced tab.
To indicate how long to keep changes, select Track changes options, and set the number of days.
To indicate how long to keep changes, select Track changes options, and set the number of days.
To indicate when changes should be saved, select Update changes options, and set a time internal.
           To resolve conflicting changes, select one of the Conflicting Changes Between Users options.
           Select the Include In Personal View check boxes.
           Click OK.
Click OK.








7.8.Workbook Sharing
7.8.1.Enable Workbook SharingEnable Workbook Sharing
7.8.2.Change Sharing OptionsChange Sharing Options
7.8.3.Protect a shared workbookProtect a shared workbook
7.8.4.Marking a Workbook as Read-Only: Mark a Workbook as FinalMarking a Workbook as Read-Only: Mark a Workbook as Final
7.8.5.Enable editing for a workbook marked as finalEnable editing for a workbook marked as final
7.8.6.Send a Workbook for Review Using E-MailSend a Workbook for Review Using E-Mail
7.8.7.Send a Workbook by Internet FaxSend a Workbook by Internet Fax