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.

How do you get a sharing link for this workbook in Excel?

Share a workbook in Excel for the web

1. Select File > Share > Share with People (or select Share in the top right).
2. In the Enter a name or email address box, type the email addresses of people you want to share with.

How do I turn off shared workbook in Excel 2010?

You can turn off sharing by following these steps:

1. Display the Review tab of the ribbon.
2. Click the Share Workbook tool, in the Changes group. Excel displays the Share Workbook dialog box.
3. Clear the Allow Changes check box.
4. Click on OK.

Where are shared Excel files?

To see the files that others have shared with you:

1. Open Word, Excel, or PowerPoint. If you already have a document or workbook open, select File.
2. Scroll down and select the Shared with Me tab, or select Open > Shared with Me.

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.

Excel 2010 Tutorial Sharing Workbooks Microsoft Training Lesson 16.1

44 related questions found

How do I share an Excel 2010 workbook?

Set up a shared workbook

1. Click the Review tab.
2. Click Share Workbook in the Changes group.
3. On the Editing tab, click to select the Allow changes by more than one user at the same time. ...
4. In the Save As dialog box, save the shared workbook on a network location where other users can gain access to it.

Can't find shared workbook Excel?

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.

How do I open a shared Excel file on my desktop?

To open and edit a file in the Office desktop app while in the Classic version of OneDrive or SharePoint:

1. Select the file in OneDrive or SharePoint.
2. Select the More icon , then select Open.
3. Select Open in (app) (such as Open in Word).

How do I find shared files on a team?

Files that you upload in a one-on-one or group chat are stored in your OneDrive for Business folder and are shared only with the people in that conversation. You can access them from the Files tab in the chat, the Files page in Teams, and your OneDrive mobile app.

How do I view shared files in Microsoft teams?

To view files shared during meetings:

1. Within the Microsoft Teams application: Navigate to the Files tab.
2. Within the Microsoft Teams application: Navigate to the Files tab. Click Open in SharePoint.
3. In a browser: Log into Microsoft 365 at IU . ...
4. In a browser: Log into Microsoft 365 at IU .

Why is my shared workbook locked?

If you are trying to co-author, the “locked” error can occur if the file uses a feature that is not supported by co-authoring. Ask the person who has the file open to do one or more of the following. The first thing to try is to turn off the Shared Workbook feature.

What is a shared workbook in Excel?

Important: "Shared Workbooks" is an older feature that allows you to collaborate on a workbook with multiple people. This feature has many limitations, and has been replaced by co-authoring. Excel co-authoring is available in Microsoft 365 Apps Excel desktop client and Excel for the Web for Microsoft 365 subscribers.

Where is the editing tab in Excel?

you can click Menus tab to get back the classic style interface, and then you will find the Edit menu easily. Click the arrow next to the Tools; you may get the familiar functions in the drop down menu.

How do you share a team in Excel?

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.

How do you turn an Excel file into a link?

Just select the cell where you want to insert a link and do one of the following:

1. On the Insert tab, in the Links group, click the Hyperlink.
2. Right click the cell, and select Hyperlink… from the context menu.
3. Press the Ctrl + K shortcut.

How do you send a link to an Excel file?

How to Insert a Hyperlink

1. Select the cell containing the text or select the object (Shape or Picture)
2. CTRL+K to open the Hyperlink dialog box or go to the Insert tab of the ribbon and select Hyperlink.
3. You can now choose the location that you want to link to from: An existing file or web page. A place in this document.

Where are teams Chat stored?

Microsoft Teams chat history is stored in a hidden file in the user's mailbox, which cannot be accessed through Outlook or OWA. Moreover, the hidden files are not even accessible to users or administrators.

How do I share a link in Microsoft teams?

Send a link

1. To send a link, select Format beneath the message box, then select Insert link .
2. Add display text and the address, select Insert, or copy and paste the link into the message box, and then select Send .

Where are teams chats stored locally?

Chats are stored in the users Outlook with shared files in the users OneDrive. Conversations are stored in the Groups Outlook with shared files in the Groups SharePoint site.

Can't open Excel from teams?

If Teams won't open Office files in the desktop app, make sure you're using the correct URL protocol settings. Additionally, update your Office and Teams versions, clear your Teams cache, and repair Office. If the problem doesn't go away, reinstall your Office packages and Teams app.

What is an ODS file?

Files with . ods extension stand for OpenDocument Spreadsheet Document format that are editable by user. Data is stored inside ODF file into rows and columns. ... ODS files can also be converted into other spreadsheet formats as well like XLS, XLSX and others by different applications.

How do I open an Excel spreadsheet in Excel Online?

Just bookmark to open it in a click. Or install Microsoft's Office Online Chrome extension for one-click access to Microsoft Excel Online and every other Office Online app. Alternately, if you open a spreadsheet from OneDrive or the Recent list, Excel will open it in an online viewer first.

Which file types share info in a spreadsheet?

Some of the most popular spreadsheet file formats are Comma Separated Values ( CSV ), Microsoft Excel Spreadsheet ( xls ) and Microsoft Excel Open XML Spreadsheet ( xlsx ).

Can multiple users edit an Excel spreadsheet at the same time in SharePoint?

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.

How do you co-author in Excel?

Co-author a workbook

1. Select Share.
2. Upload your file to OneDrive, if you haven't already.
3. Set permissions and select Apply. ...
4. Add the names of who to share with, and an optional message.
5. Select Send.
6. Select the initials in the upper right to see who else is working on the file and where they are in the file.