Thursday, July 19, 2012

How to Allow a Shared Workbook


Microsoft Excel 2003
1. Launch Excel 2003, then open the Excel workbook you want to share with other users on the network.
2. Click the 'Tools' option on the menu bar, then click 'Share Workbook.' Wait for the 'Share Workbook' options dialog window to appear.
3. Click and enable the checkbox next to the label that reads 'Allow Changes by More Than One User at the Same Time. This Allows Workbook Merging.' Click the 'OK' button.
4. Click the 'File' > 'Save' option on the menu bar to save the permission changes to the workbook.
Microsoft Excel 2007 or 2010
5. Open Microsoft Excel, then open the workbook you want to share.
6. Click the 'Review' tab on the 'Office Ribbon,' then click 'Share Workbook.'
7. Click the 'Editing' tab, then enable the checkbox next to 'Allow changes by more than one user at a time. This also allows workbook merging.'
8. Click the 'Advanced' tab, then select options for tracking and updating changes to the shared workbook. Click 'OK.'
9. Save the workbook to save the sharing and permission changes for the file.

Blogger news