how to make an excel file shared in sharepoint

You are free to accept or reject their changes, and after the desired changes have been incorporated, you can stop sharing the workbook. Now, you and your colleagues can work on the same Excel file at the same time.

If done correctly, the word will appear to the right of the workbook's name as shown in the screenshot below:

Save you Excel file to a network location where other people can access it (the fastest way is by using the Ctrl + S shortcut).

Optionally, switch to the Advanced tab, select the desired settings for tracking changes, and click OK.įor example, you may want to have changes updated automatically every n number of minutes (all the other settings on the screenshot below are the default ones).

This also allows workbook merging check box on the Editing tab.

The Share Workbook dialog box will appear, and you select the Allow changes by more than one user at the same time.

On the Review tab, in the Changes group, click the Share Workbook button.

With the workbook open, perform the following steps to share it: You can keep track of those changes and accept or reject them.

This section shows how to share an Excel workbook for multiple users by saving it to a local network location where other people can access it and make edits.

Remove users from Excel shared workbook.

How to merge different copies of a shared workbook.

Resolve conflicting changes in a shared workbook.

How to share Excel workbook and protect change tracking.

How to share Excel file for multiple users.

By sharing an Excel file, you are giving other users access to the same document and allow them to make edits simultaneously, which saves you the trouble of keeping track of multiple versions. The recent versions of Excel 2010, 20 make it easy to share and collaborate on workbooks. While fast and convenient, the former method created multiple versions of the same document, and the latter produced a secure though non-editable copy.

In the past, when you needed to share an Excel workbook with someone, you could send it as an email attachment or save your Excel data to PDF for printing. These days more and more people are using Microsoft Excel for team work. In this tutorial, you will find full details on how to share Excel workbook with other people by saving it to a local network or OneDrive, how to control user access to a shared Excel file and resolve conflicting changes.

How to make an excel file shared in sharepoint