Sharing and Allow Users to Edit Changes in Microsoft Excel 2010

In this article, we will learn how to share and allow users to edit changes in Microsoft Excel 2010.

Microsoft Excel allows multiple users to modify the data in a worksheet simultaneously. You can create a shared workbook & place it on a shared location where many people can make the changes of the contents of the file at the same time. If an employee is working on multiple projects, and needs to update the status of the task as it finishes so that the information will be passed to the group members who are working along with. It will minimize any chance of two people doing the same task. All persons involved can enter the information for their projects in the same workbook.

The owner of a shared workbook can manage it by removing users from the shared workbook and resolving any conflicting changes. After doing all the changes, you can stop sharing the workbook.

Share a Workbook

1) Create a new workbook or open an existing workbook that you want to share to multiple users to modify any changes.

There are some limitations in a shared workbook & all the features are supported.

The following features are not working in a shared workbook:

• Conditional Formatting
• Data Validation
• Create or change Charts
• Pictures
• Merged cells
• Hyperlinks
• Objects including drawing objects
• Scenarios
• Outlines
• Pivot Table Report
• Subtotals
• Data Tables
• Workbook and Worksheet Protection
• Macros.

You cannot make changes to these features after sharing the workbook.

If you want to include any of the above listed features, then you should add them before you save the workbook as a shared workbook.

 
Steps to Share Workbook
 

• Click on Review ribbon
• In the Changes group, click on Share Workbook

 

 
If you see this information then
 

 

• You need to Click on File ribbon
• Select Trust Center

• Click on Trust Center Settings
• Uncheck the “Remove personal information from file properties on save”.

• Click on OK
• You will be able to share workbook
• Check the box “Allow changes by more than one user at a time. This also allows workbook merging”.

• Click on Advanced tab & select the options that you want to use for tracking & updating changes.

• Click on OK
• You will see the dialog box appearing & asking: Do you want to continue sharing the workbook?

• Click on OK.
• After that, you will notice that the file has been shared