Sharing workbooks

By Neil Shorney, Director, Naturally Sales Ltd.

Tired of having to exit an Excel workbook every time a colleague wants to make a change?

You can use the “Share workbook” tool, which you’ll find on the “Review” tab. If you click this button, you’ll find a check-box to “allow changes by more than one user at the same time”. This will re-save the workbook, and you’ll see the word “Shared” at the top by the workbook name. Now anyone can be in the workbook and modify it together. If there are any conflicts (i.e. 2 people trying to change the same cell), then the second person to make the change has the option to accept the previous change or insert their own.

For added security and tracking, this can be combined with various passwords.