Click File > Options > Quick Access Toolbar. Open the list under Choose commands from and select All Commands. Scroll down that list until you see Share Workbook (Legacy). Select that item and click Add.
Set up a shared workbook
- Click the Review tab.
- Click Share Workbook in the Changes group.
- On the Editing tab, click to select the Allow changes by more than one user at the same time. …
- In the Save As dialog box, save the shared workbook on a network location where other users can gain access to it.
Share your Excel workbook with others
- Select Share.
- Select permissions and then Apply.
- Add people.
- Type a message if you like.
- Select Send.
How do I allow others to edit an Excel spreadsheet?
Click Share Workbook in the Review tab. Click Editing and check the “Allow changes by more than one user” box. Click Advanced and select the track changes and update features you want to use. As other users edit and save the workbook, each person’s copy will update.
To be able to share a workbook, some privacy settings need to be disabled. Go to File > Excel Options > Trust Center, click the Trust Center Settings… button, and under the Privacy Options category, uncheck the Remove personal information from file properties on save box.
If the file is a Word, Excel, PowerPoint or Visio file, the easiest way to share it is to open the file in its corresponding Office for the web or desktop app. Select Share at the top right corner of the window.
Can multiple users work on Excel spreadsheet same time?
You and your colleagues can open and work on the same Excel workbook. This is called co-authoring. When you co-author, you can see each other’s changes quickly—in a matter of seconds.
Share and collaborate with Excel for the web
- Select Share.
- Set permissions. Allow editing is automatically checked. …
- Enter the names or email addresses of who to share with.
- Add a message (optional).
- Select Send. Or, select Copy link to get a link to the file.
Co-authoring in SharePoint Server lets multiple users work on a document, at any time, without interfering with each other’s changes. … If you have SharePoint Server configured to use Office Web Apps Server, users can also co-author documents in Word, PowerPoint, Excel, and OneNote Web Apps.
Click Review > Share Workbook. On the Editing tab, select the Allow changes by more than one user … check box. On the Advanced tab, select the options that you want to use for tracking and updating changes, and then click OK.
Why would you set up a workbook to be shared if you are the only one using the workbook? You have data for Regions, Products, and Customers.