IT AND COMPUTER Microsoft Office Simple hacking Windows Editor

How to setup to for Excel sheet to used by multiple person at same time

How to setup to for Excel sheet to used by multiple person at same time

As we all are using Microsoft product and we all are facing some problem but the main issue is the if we are working on a network and use a common file Excel file for update data then it is very lengthy to update data at same time,

 

So resolve this issue, Excel have one facility that multiple people can use one Excel file at same time, it’s call Share Document To Enable this feature you have to follow the below simple Steps,

First open one excel file that you have to set up this process,

Then Go to Review menu it place on Front of Excel sheet, and then select the Share Workbook 

 

Click on Share Workbook,When you click on it , it display some error like below,

Not to worry to resolve this error go to blelow,

 

File –>Option–>Trust Center–>Trust Center Setting–>Privacy Options

 

Unchecked the option and then click on OK Button,

Then again select the Review menu and then select the Share Workbook 

Then check on  Allow changes by more then one user at the same time.

 

And then click on ok button so setting done now you can use one Excel sheet by multiple user at same time,

Note:-This setting for office 2013

 

 

Leave a Reply

Your email address will not be published.