Share Excel Workbook

Excel 2007 allows to share workbooks between users and update them at the same time (Feature long overdue). You have to do a few steps to enable it first:

1. Open your Excel workbook.

2. On the Review tab, in the Changes group, click Share Workbook.

3. On the Editing tab, place a check beside the option to Allow changes by more than one user at the same time. This will also allow workbook merging.

4. Click the Advanced tab and under Update Changes select Automatically every. The default is 15 minutes, but it can be changed to whatever value you desire.

5. Click OK.