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.
Contents
Can multiple users edit an Excel spreadsheet at the same time?
You can edit the same Excel file with multiple users through a feature called co-authoring. This feature lets multiple people make changes in a document stored on a remote, so-called cloud server with their actions highlighted in different colors.
Save and share a workbook
Click File > Share > Save to Cloud. Invite people to collaborate on the workbook by typing their names or email addresses in the corresponding box. Make sure Can edit is selected in the dropdown list on the right (default) and click Share.
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.
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.
How do you make Excel editable by multiple users in teams?
Click Review > Share Workbook. On the Editing tab, select the Allow changes by more than one usercheck box. On the Advanced tab, select the options that you want to use for tracking and updating changes, and then click OK.
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.
To share a workbook:
- Click the File tab to access Backstage view, then click Share.
- The Share pane will appear.
- On the Share pane, if your document is saved to OneDrive, click the Share with People button.
- Excel will return to Normal view and open the Share panel on the right side of the window.
It can be done with a simple click. Any team member can open the file on the Office desktop or in the Office Online app and click the Share button. After doing that, you can enter the receivers’ email addresses or send them a link.
Open the file you want to send. In the Quick Access Toolbar, click Send to Mail Recipient to open an email message. Your file will appear in the body of the message. Enter the recipients’ aliases, edit the subject line and message body as necessary, and then click Send.
How do you create a link to an email address in Excel?
Create a link to an email address
- On a worksheet, select the cell where you want to create a link.
- On the Insert tab, select Hyperlink.
- Under Display Text:, type the text that you want to use to represent the link.
- Under E-mail address:, type the email address that you want.
- Select OK.
How do you attach an Excel file as a link in an email?
Open the email in your email client (either new or reply) and press the Attach button. Now that the Insert File window is open, you just need paste (Ctrl+V) the full file path in the File Name box and press Enter. That might seem like a lot of steps, but it is actually pretty fast once you practice it a few times.
Co-author a workbook
- Select Share.
- Upload your file to OneDrive, if you haven’t already.
- Set permissions and select Apply.
- Add the names of who to share with, and an optional message.
- Select Send.
- Select the initials in the upper right to see who else is working on the file and where they are in the file.
How do I save an Excel sheet to another file?
Save a single worksheet
- Right-click the worksheet name tab.
- Click select Move or Copy.
- Click on the Move selected sheets to Book drop-down menu. Select (new book).
- Click OK. Your new workbook opens with your moved worksheet.
- Click File > Save in your new workbook.
Other share options
- Next to the file tap More options. > Copy link. This lets you share a link outside of Teams. Or.
- Tap More options. > Send a copy. This will download a copy of the file to your phone. You can then choose how you want to share it.
How do I give permission to edit a team?
From the Manage access menu, you can add and set permissions for new or existing team members, or change the appropriate viewing privileges as needed; “can view (cannot make changes)” and “can edit (make any changes).” 4. Choose “Grant Access” button at the bottom to confirm the file access settings in Microsoft Teams.
Work on a file together
- In a team conversation or in the Files tab, select More options. next to the file.
- Choose if you want to edit the file in Teams, on your desktop, or online.
- Select Start conversation to add a message about the file.
- Type your message or @mention someone and select Send.