Download Article
Download Article
You can share your workbook with others so you can work together on the same file at the same time using Excel for the web. This wikiHow will show you how to share an Excel workbook online with Excel for the web.
Steps
Download Article
-
Go to https://office.com/launch/excel and log in if prompted. You can use any web browser to share a workbook on Excel for the web.
-
Open your project or create a new one. You can find your workbooks under "Recent," "Pinned," or "Shared with me" or you can click from the templates along the top of the page to create a new workbook.
- If you already have an Excel workbook saved on your computer that you want to share, you can click Upload & Open to upload the file to Excel online and continue following the steps to share your project.
Advertisement -
Click Share . You'll see this green button in the top right corner of the page.
-
Set the permissions. This defaults to "Anyone with the link can edit" and you can click that text to be able to set other permissions, such as a password or expiration date.
- If you change the default permissions, click Apply to return to the previous page.
-
Enter the name, group, or email of who you want to share the workbook with. You can also add a message if you'd like, but that's optional.
-
Click Send . A link to your workbook will be sent to the people you entered previously. Instead, you can click Copy Link to save the link to your clipboard so you can send it out manually.
- When a person edits your workbook and you're also editing the workbook, you'll see a colored outline represent their cursor, so when they are working on a cell, that cell will become outlined in their editing color.
- If someone adds a comment to a cell, you can see those comments by going to Review > Comments > Show comments . Otherwise, a purple flag will appear in cells with comments and clicking that cell will reveal the comment.
- If another person is editing the workbook at the same time as you, both of you have the ability to use the chat feature, which you'll find in the upper right corner of the page. [1] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
Tips
Common Questions: Sharing Excel Workbooks
Can you share just one sheet in Excel online?
Right-click the desired sheet and select Move or Copy... . In the "To book:" dropdown select (new book) and make sure the Create a copy box is checked. Save this new workbook. You can then share this new workbook with the singular sheet using the steps above.
Can multiple users edit an Excel spreadsheet at the same time?
Click the Share button in the upper-right corner and upload your spreadsheet to OneDrive or SharePoint. Enter the emails of your collaborators and an optional message and click Invite to send an invitation link. Users who are invited will be able to work in the same Excel spreadsheet concurrently. [2] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
How do I track changes in a shared Excel file?
You can track changes in a Shared Workbook. Go to Review > Share Workbook > Editing . Check the box next to Allow changes by more than one user at the same time . Go to Advanced and click Keep change history for . In the days box, enter how many days of change history you want to keep. [3] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
Why can't I share an Excel workbook?
To turn the Shared Workbook setting on, go to File > Options > Quick Access Toolbar . Under "Choose commands from" select All Commands and add the following commands: Share Workbook (Legacy), Track Changes (Legacy), Protect Sharing (Legacy), and Compare and Merge Workbooks. [4] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
References
- ↑ https://support.microsoft.com/en-us/office/share-and-collaborate-with-excel-for-the-web-c8ab30a3-c0fa-473e-b508-0f5186bd47a2
- ↑ https://support.microsoft.com/en-us/office/collaborate-on-excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104
- ↑ https://support.microsoft.com/en-us/office/track-changes-in-a-shared-workbook-22aea671-cac7-4fa3-845d-eeb23725bd15
- ↑ https://support.microsoft.com/en-us/office/what-happened-to-shared-workbooks-150fc205-990a-4763-82f1-6c259303fe05
About This Article
1. Go to https://office.com/launch/excel
and log in if prompted.
2. Open your project or create a new one.
3. Click Share
.
4. Set the permissions.
5. Enter the name, group, or email of who you want to share the workbook with.
6. Click Send
.
