Allowing others to edit ranges


show more Allowing others to edit ranges provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

Allowing others to edit ranges

When you are working with Excel spreadsheets, you often want to be able to share the workbooks so that you can have other people add information into one common area. We're going to explore sharing the workbooks right now. If I go up to the Share Workbook command, under my Changes tab, I can allow multiple people to work on a workbook at the same time. So, no longer do I have to use the workbook, and then send it over to sue to work on after I've saved my changes, we can both work on the worksheet at the same time and all of our changes will be tracked and merged when the next person opens up the information. So let's see how this works. If I want to share this workbook I click on the Shared Workbook command and I and see a Share Workbook window.

The first tab allows me to make an important decision. It asks me, do I want to allow changes by more than one user at the same time? This is also going to allow workbook merging. This in very, very important. If you don't allow c...

Allowing others to edit ranges
Video duration: 4m 3s 5h 13m Beginner

Viewers:

Allowing others to edit ranges provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...