How to Share a Workbook

By Joshua Laud

Microsoft Excel, sometimes known as Microsoft Office Excel, is Microsoft's proprietary spreadsheet management software. You can use Microsoft Excel to analyze, interpret and arrange data. Sometimes you will need to gain input or contribution from multiple users at one time. Using Microsoft Excel's shared workbooks feature, you can allow multiple people to work simultaneously on an Excel document across a network.

Setting Up Workbook Sharing in Excel 2003 or Earlier

Step 1

Open Microsoft Excel and then open the workbook that you want multiple people to be able to edit at once.

Step 2

Click "Tools" and then click "Share Workbook" to load the Share Workbook options window.

Step 3

Check the "Allow Changes by More Than One User at the Same Time. This Allows Workbook Merging" option under the "Editing" tab. Click "OK."

Step 4

Click "File" and then "Save" to update the interactivity to the workbook.

Step 5

Tell other users that they can open the workbook. At any time, click "Tools" and then "Share Workbook" to see who has accessed the workbook and who is accessing it at any given time.

Setting Up Workbook Sharing in Excel 2007 or Later

Step 1

Open Microsoft Excel and then open the workbook that you want multiple users to edit simultaneously.

Step 2

Click the "Review" tab in the right-side window pane. Click "Share Workbook" under the "Changes" section.

Step 3

Check the "Allow Changes by More Than One User at the Same Time. This Allows Workbook Merging" option under the "Editing" tab. Click "OK."

Step 4

Click "File" and then click "Save" to update the document for workbook sharing. Other users can now access the selected workbook simultaneously.