Microsoft Excel has many features, Typically Excel workbook can be editable by one user only. If multiple users can try to use, it will be open read-only format. Sometime multiple people would like to access one excel workbook simultaneously. In this situation how they can do this?
 
microsoft-excel-2016

Share Excel workbook for multiple user

Fortunately, excel workbook have the option Share Workbook, following steps guide you how to setup Share Workbook:1. Open the excel sheet what you like to share

  1. Open the excel sheet what you like to share
  2. Go to Review tab, click on the Share Workbook (legacy)
  3. edit-excel-workbook-multiple-users-01

  4. A popup message appears, you have to disable the privacy settings, click OK to close the window
  5. Go to File -> Options -> Trust Center
  6. Then click on the Trust center settings button
  7. edit-excel-workbook-multiple-users-03

  8. Select the Privacy Options category, under Document specific settings unselect the option of “Remove personal information from file properties on save” then click OK to save the settings
  9. edit-excel-workbook-multiple-users-04

  10. Now go Review Tab and click on the Share Workbook
  11. In the Share Workbook enable the option “Allow changes by more than once user at the same time”
  12. edit-excel-workbook-multiple-users-05

  13. A Confirmation message will be appearing click OK to save the settingsNow your Excel workbook can be editable by multiple person at a time.

Now your Excel workbook can be editable by multiple people at a time.

The following two tabs change content below.
Jey Ganesh is a Tech Blogger of techthagaval.com, Here you can find Technology, Internet and Mobile solutions. You can also engage with techThagavel via RSS, Newsletter. Email: admin@techthagaval.com

Comment :