Contents
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.
Step 2: Share it
- If you uploaded the file, click the filename to open it.
- Click the Edit in Excel button.
- Click Open Microsoft Excel.
- When the file opens in the Excel program, you may see a yellow bar which says the file is in Protected View.
- Click Share in the upper-right.
- Click Invite People.
What is the advantage of sharing a workbook?
An advantage of sharing spreadsheets means that you can encourage employee collaboration. One spreadsheet shared among several employees cuts down on multiple files, which can contribute to information being lost or overwritten.
Why can’t I share my Excel workbook?
If Microsoft Excel refuses to share a certain workbook, most likely it’s because of one of the following reasons: Workbooks that have tables or XML maps cannot be shared. To be able to share a workbook, some privacy settings need to be disabled.
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).
1. Open a workbook. 2. On the Review tab, in the Changes group, click Share Workbook. The Share Workbook dialog box appears. 3. On the Editing tab, click the check box and click OK. Excel saves the workbook. You can now work with other people on the same workbook at the same time. The screen above shows you who has the workbook open.
How to create/make a shared workbook in Excel?
Create a Shared Workbook in Excel In Microsoft Office 2010/2013, click File > New and select the workbook type you need to create a new workbook. Click Review > Share Workbook to open the Share Workbook dialog. In the pop-up Share Workbook dialog, click Editing tab and check the box on which beside Allow changes by more than… Then click File > Save As to open the Save As dialog, and select a public folder to save it. (Tip: You may sure that… See More….
Why Cant I share a workbook in Excel?
If Microsoft Excel refuses to share a certain workbook, most likely it’s because of one of the following reasons: Workbooks that have tables or XML maps cannot be shared. To be able to share a workbook, some privacy settings need to be disabled.
Upload the workbook