HOW TO SET MS EXCEL SHARE (OPEND BY MULTI USER AT ONCE)

HOW TO SET MS EXCEL SHARE (OPEN BY MULTI USER AT ONCE)

You might always open an Excel file but its show fore read only.
This is the tips for 1 file of excel can be open by multiple user at once.

1. Click the Review tab.
2. Click Share Workbook in the Changes group.
3. On the Editing tab, click to select the Allow changes by more than one user at the same time. This also allows workbook merging check box, and then click OK.
4. In the Save As dialog box, save the shared workbook on a network location where other users can gain access to it.

Oped Excel file

and follow the step

step 1

step 2

step 3

and save the file , close and open back.