قالب وردپرس درنا توس
Home / Tips and Tricks / Everything You Need to Know About Co-Authoring in Excel

Everything You Need to Know About Co-Authoring in Excel



 The Excel Logo.

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

9659004ShareYourWorkbookforCo-Authoring

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.

 Click

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.

The people

 Send an invitation to open a shared 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.

 Get a sharing link for the workbook

You can see a

 The Share with a list of people a workbook was shared with.

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."

 Click

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.

 A shared workbook showing one author's changes in blue.

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.

 The AutoSave feature in the

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.

 Click

Type your comment, and then click the Post button (the green arrow icon).

 Type your comment, and then click the Post button.

The comment

 A purple comment icon in the corner of a cell.

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.

 Click

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

The option to have conversations in the workbook via Comments Skype.


Source link