Open Excel file to allow editing from multiple persons

 

There was a requirement like one Excel file needs to be shared with multiple persons for editing simultaneously.

To provide such facility in Excel 2010 below steps can be followed.

 

 

  1. Create a folder and place the Excel file into it
  2. Share that folder with the persons to whom you want to allow editing by giving modify permissions
  3. Now open the excel workbook. On the Review tab, in the Changes group, click Share Workbook

  4. On the Editing tab, select the Allow changes by more than one user at the same time. This also allows workbook merging check box.
  5. Close the excel file and reopen
  6. You will see the file is opened in “SHARED” mode on all the locations
  7. When any body saves the changes. to get reflected on locatiosn everybody as to save.

 

Thank you.

Prashant Deshpande

Advertisements

Leave a comment

Filed under Uncategorized

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s