Wednesday, August 15, 2012

How to Control Multiple Users on One Excel Spreadsheet


1. Open the Excel spreadsheet you wish to share among multiple users.
2. Click 'Tools' and select the 'Share Workbook' option. A pop-up window will appear.
3. Place a check mark in the check box at the top of the 'Editing' tab on the Share Workbook pop-up window.
4. Click the 'Advanced' tab at the top of the 'Share Workbook' pop-up window. The window will change to present a variety of customizations for controlling multiple users on the Excel spreadsheet.
5. Choose desired options on the 'Advanced' tab. You may change the history log time frame and control how updates are handled.
6. Click the 'OK' button. Excel will immediately save the workbook and provide a pop-up message to indicate this. The Excel spreadsheet is now set up to handle multiple users.
7. Place the spreadsheet on a shared network drive where multiple computers can access it.
8. Save the spreadsheet on any computer to immediately see updated changes by other users currently working on the same file.

Blogger news