Co-authoring enables you and your colleagues to work on the same Excel workbook simultaneously. Everyone sees all changes in real-time, and Excel works for all of them.
To co-author in Excel, you need the latest version of Office 365. [1
To co-author a workbook, you first need to save it to OneDrive or a SharePoint Online library. To share your workbook with others, click "Share" in the top right corner.
If you have not already saved the workbook you want to share with OneDrive or SharePoint, you ' Be prompted to do so.
When the Share pane opens, type the email addresses of the people with whom you want to share the workbook.
Next, click the drop-down button or just view the workbook. You can also type a message if you'd like.
The Share options on an Excel workbook.
If you do not want to share the workbook via email , click "Get a Sharing Link" at the bottom of the Share pane, and you'll share it.
You can see a
How Others Can Open a Shared Workbook
The first time someone opens a shared workbook, it opens in excel on the web. [Edit] ” width=”650″ height=”271″ src=”/pagespeed_static/1.JiBnMqyl6S.gif” onload=”pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);” onerror=”this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);”/> ” width=”650″ height=”271″ src=”/pagespeed_static/1.JiBnMqyl6S.gif” onload=”pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);” onerror=”this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);”/>
If someone wants to work in the desktop version of Excel, he can click "Open in Desktop App."
Co-Authoring in Excel
In most versions of Excel, including Office 365, for the Web , and for mobile-you see your co-authors' selections in real-time. And each person's selections appear in a different color so you can identify them easily.
Unfortunately, all versions of Excel support this feature. Even if you can not see their selections,
To make the selections of all co-authors in real-time, you have to use Excel for Office 365 and turn on the AutoSave feature-you'll find it in the top-left corner of the toolbar.
Annotate with Comments
A great way to collaborate without changing cell values is to use comments. Comments makes it easy to leave a note in Excel before you make a change.
Type your comment, and then click the Post button (the green arrow icon).
All authors can read your comment when They position their mouse over the cell.
To reply to a comment, click the comment icon.
If you want to see all the comments in a workbook, click "Comments" in the top-right corner.
The "Comments" panel opens, and you can read all the comments in the workbook in a conversational format. Each comment also includes a reference to the cell in which it's stored.
The option to have conversations in the workbook via Comments Skype.