Microsoft Office Tutorials and References
In Depth Information
Share a Workbook with Other Users
Share a Workbook
with Other Users
You can allow multiple users to modify a workbook
simultaneously by sharing the workbook. Once you
have shared a workbook, other users can open the
workbook via a network connection and edit the file
at the same time. Note that Excel cannot share a
workbook that contains a table, so you need to
convert any tables to ranges before performing this
task. See Chapter 10 for more information.
When you share a workbook, Excel automatically
begins tracking the changes made to the file. For
more information on this feature, see the following
section, “Track Workbook Changes.”
Share a Workbook with Other Users
1 Display the workbook you want
to share.
2 Click the Review tab.
3 Click Share Workbook (
).
The Share Workbook dialog
box appears.
4 Click the Editing tab.
5 Click the Allow changes
by more than one user at
the same time check box
(
changes to
).
6 Click OK.
Search JabSto ::




Custom Search