Computer Science, asked by shubhamgupta31p92inv, 1 year ago

What do u mean by sharing worksheet data??

Answers

Answered by bhavikaji
6

Enabling the Shared Workbook feature

Be certain that you want to use this method before continuing. Shared Workbooks have limitations, and one in particular is the inability to edit using Excel Online. Therefore we highly recommend co-authoring, which is the replacement for Shared Workbooks.

Create a new workbook or open an existing workbook. Then place it on a network location. For example, put it on a location like \\server_name\folder_name. Don't put the file on OneDrive or SharePoint. If you prefer those locations for the file, co-author the workbook instead.

Click Review > Share Workbook.

Note that in newer versions of Excel, the Share Workbook button has been hidden. Here's how to unhide it.

On the Editing tab, select the Allow changes by more than one user ... check box.

On the Advanced tab, select the options that you want to use for tracking and updating changes, and then click OK.

If this is a new workbook, type a name in the File name box. Or, if this is an existing workbook, click OK to save the workbook.

If the workbook contains links to other workbooks or documents, verify the links and update any links that are broken.

Click File > Save.

When you're done, - Shared will appear at the top of the Excel window, next to the filename.

Similar questions