Home »  Software »  Office Suite Software

How Do I Share a Workbook in Microsoft® Excel 2010

September 23, 2011  |  Difficulty: Easy

How to share a workbook in Microsoft® Excel 2010 so other people will see the changes

Many companies use Microsoft® Excel to store, organize and manipulate data. This tool is great for sharing information, results and reports. The ability of more users having access to one workbook file was not available until Microsoft® Office 2010 was released. Multiple users can open and work on the same file stored on a network location. If information were added or changed in the workbook, and then saved, other people working in the file will see the changes immediately when they save the document. To share a workbook in Microsoft® Excel 2010, follow the instructions below.


  1. Start the Microsoft® Excel 2010 application.
  2. Open the file you would like to share, or create a new file.
  3. Switch to the “Review” tab.
  4. Click on the “Share Workbook” icon.
  5. Check the “Allow changes by more than one user at the same time”. This would also allow the workbook to merge once users make any changes.
  6. Click on the “OK” button.
  7. Copy or save the file to the location which is accessible for future users.


  • Users should always save the document before they insert their own values. To prevent a conflict of users writing in same cell.


Most Popular Articles:

What Is the Best Backup Software for Me

Internet Security Solutions Detect Legitimate Soft

How Do I Block Internet Intruders from Spying

How Do I Choose a Data Backup Software

How Do I Install a FREE Spyware and Adware Blocker

Related Articles:

How to start working with Microsoft Access® application and create your first database

How Do I Create Microsoft Access® Database

How to format and merge cells in your Microsoft Excel® spreadsheet

How Do I Merge Cells in Microsoft Excel®

How to insert a PowerPoint® Presentation into Microsoft® Word document

How Do I Insert a Presentation into MS Word

How to insert a new line, row, or column between ones that already exist

How Do I Add a Line or Column in Microsoft Excel®

How to upload your pictures, photos, or images to share on Facebook®

How Do I Share a Photo on Facebook®

Help Us Spread the Word!

Love us on Facebook to stay updated.

Stay aware and get our best content on health, celebrity, travel, living, career and the technologies that will change the world.