- Open the workbook and make any final changes to the design and structure of the workbook so that it’s ready for use.
- Select the “Review” tab and then click the “Share Workbook” command in the Changes section of the ribbon. The Share Workbook dialog box opens.
- Check the box next to “Allow Changes by More Than One User at the Same Time.”Click “OK” to save the settings. Excel prompts you to save the workbook.
- Save the workbook to a shared location on the network.