• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 16. Sharing Workbooks > Sharing Workbooks on a Network

Sharing Workbooks on a Network

When sharing has been enabled for an Excel workbook, up to 256 network users can simultaneously view and edit the workbook. (For information on storing files on your network so they can be accessed by others, contact your network administrator.)

To enable sharing for a workbook

1.
Choose Tools > Share Workbook.

The Share Workbook dialog box appears (Figure 16.6).

Figure 16.6. Enable sharing by clicking this check box.


2.
On the Editing tab, click Allow changes by more than one user at the same time.

3.
Click the Advanced tab to review or set options for managing changes by multiple users.

4.
Click OK to dismiss the dialog box.

A confirmation dialog box appears (Figure 16.7).

Figure 16.7. Confirm that you want to share the workbook by clicking OK.


5.
Click OK to save the workbook and enable sharing.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint