Table of Contents
- #1 – How to Share an Excel File?
- #2 – Highlight the Changes Done on Excel By Other Users
- #3 – Accept/Reject the Changes Done by Other Users
Share an Excel Workbook File
As a team sometimes several users would require to work on same excel sheet simultaneously. For this, you can save the workbook as a shared workbook. After sharing the excel sheet, users can do a lot of changes in Excel like enter the data, insert new rows or columns, add and change the formulas, change the excel formatting etc.
By sharing an Excel sheet, we give access to other users for the same file and allow them to make changes simultaneously.
In this article, we will cover the following topics:
- How to share an Excel file?
- Highlight the changes done on this workbook
- Accept/Reject the changes done by other users:
#1 – How to Share an Excel File?
For sharing an Excel sheet with other users, we need to save this to a local network location where others can access it and make changes. We also can keep track of those changes and can accept or reject those changes as per the requirement.
Let’s take below example to understand how to share an excel sheet.
We have given below customer details in a workbook saved with the name of Customer Data”.
- Go to the REVIEW tab.
- Click on Share Workbook option under Changes Refer below screenshot.
- Then an Excel Share Workbook File dialog box will appear. See below screenshot.
- Under the Editing tab, tick on the checkbox and click on OK.
- By clicking on this checkbox we are giving access to other users for editing.
- The screen above shows you who has the workbook open.
- After clicking on OK one dialog box will appear with a message. Refer below screenshot.
- Click on OK.
- Save this workbook.
#2 – Highlight the Changes Done on Excel By Other Users
We can also highlight the changes which have been done by other users. Follow below steps:
- Go to the REVIEW tab.
- Click on Track Changes option in Excel under Changes section. Refer below screenshot.
- This will show you two options as per below screenshot.
- Click on Highlight changes.
- This will open a dialog box here. See below screenshot.
- Click on OK.
- Now click on Protect Shared Workbook option under Changes section as shown in below screenshot.
- It will open a dialog box. Tick on the checkbox as shown in below screenshot.
- Click on OK.
- Now Excel will show the changes done by the users.
- How does it look after changes? For your reference, I am going to make some changes in share excel workbook file and save that changes.
- Now the sheet automatically highlights the changes wherever done by me as shown in below screenshot.
#3 – Accept/Reject the Changes Done by Other Users
We can accept or reject the changes done by other users if those changes are not according to us. For this follow below steps:
- Go to the REVIEW tab.
- Click on Track Changes option under Changes section as done before.
- Choose the Accept/Reject Changes option from the list as shown in below screenshot.
- Then a dialog box will appear as shown in below screenshot.
- Click on OK.
- Then a dialog box will appear and it will show you all the changes one by one as shown in below screenshot. It will also highlight the cell in the spreadsheet where that changes made.
- Click on the Accept button to accept the changes or Reject button to reject the changes.
Important Points to Remember about Share workbook File in Excel
Excel shared workbook file feature has some limitations. The reason is not all features are fully supported in excel shared workbooks. Some of the limitations are:
- Sorting and filtering the data in excel
- Conditional formatting
- Merging excel cells
- Hyperlinks in Excel.
You can use those features but won’t be able to add or change them.
- After sharing the workbook, when one or more users are editing on the same workbook simultaneously. Some edits can affect the same cells too.
- In these situations, Excel sheet keeps the changes of the user who saved the workbook first.
- When another user saves the workbook, it will display the Resolve Conflicts dialog box.
- It will display all the information about the conflict changes.
- To resolve conflicts, you can take action accordingly by clicking on Accept Mine, Accept Other etc.
You can download this Share Excel Workbook file template here – Share Excel Workbook Template
Recommended Articles
This has been a step by step guide to Share Excel Workbook File. Here we discuss how to Share an Excel Sheet, highlight the changes done in excel and how to accept/reject the changes done by other users along with practical examples and downloadable templates. You may learn more about excel from the following articles –
Leave a Reply