Micro Soft Excel – Microsoft Office

Asked By 7060 points N/A Posted on -
qa-featured

MS Excel workbook can be share with other user and allow two users to use workbook at same time. Which feature is being used in this function?

SHARE
Best Answer by oviman
Answered By 0 points N/A #82777

Micro Soft Excel – Microsoft Office

qa-featured

It is possible to create a shared workbook and store it on a network location where various people can modify the contents at the same time. An example is when people under the same workgroup that handles projects and one needs to check on the status of each projects, the workgroup can use a shared workbook to trace the status of the projects and amend the information if needed.

If you are the owner of the shared workbook, you can handle it by controlling the user access on the shared workbook and fix any issues. When the changes is done, you can stop the workbook sharing.

 

Best Answer
Best Answer
Answered By 0 points N/A #82779

Micro Soft Excel – Microsoft Office

qa-featured
  • Microsoft Excel spreadsheets are often the lifeblood of a project. Their columnar structure makes it easy to organize changes and track progress. Often, multiple individuals are at work on a project, and thus many users require access to the same Excel spreadsheets. Most computer files cannot be edited by more than one person simultaneously. Excel, however, is designed to allow shared spreadsheets. Once the feature is activated, the program is an ideal choice for managing data input between many people.

Instructions

  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.

Tips & Warnings

  • In the event that two users edit the same cells in the Excel file, the second user who saves the workbook is presented with a pop-up question. This notifies the user that she has made changes to a cell altered by another user since her last save. She is given the option of keeping her own changes, and thus deleting the other user's, or deleting her recent changes. This is the common default practice when sharing Excel spreadsheets. However, this behavior may be turned off in the "Advanced" tab of the "Share Workbook" window.

 

Related Questions