Related Items  

Linux and Windows Support  

make-it-great-again

Login or Register  

If you wish to contribute an article, please login or register.

Share Excel Workbook

PrintE-mail

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.

share_excel_1

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

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.
share_excel_3

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.


Add your comment

Your name:
Subject:
Comment:
  The word for verification. Lowercase letters only with no spaces.
Word verification:
yvComment v.1.24.0
   
Copyright © 1999 - 2017 Virtual Helpme | a | Original Template: Allrounder