Protecting data in a shared spreadsheet


show more Protecting data in a shared spreadsheet provides you with in-depth training on Business. Taught by David Rivers as part of the Office 2013 New Features show less
please wait ...

Protecting data in a shared spreadsheet

A very common scenario when working with Excel is to share a workbook, that is to have more that one person having access to the data, either to make changes or update or additions. Protecting that workbook is then something to consider and there are some new options here in Excel 2013, we're going to explore them using this file named No Obstacle Sport - Customer Database3. As you can see down below there are more in than one tab. There is our main sheet, Sheet1, containing our customer data base information; and there's also a Power View, and if we switch over to that tab, you can see we're looking at a table with some tiles. Okay.

So, maybe this is an area where anyone can have access to manipulate the data and visualize it in different ways. We don't need to protect that. But if we go back to our sheet, maybe we do want to protect this sheet. Well, maybe we want to protect a part of this sheet, and that is an option now using a Range Protection, so let's talk abou...

Protecting data in a shared spreadsheet
Video duration: 5m 21s 2h 31m Appropriate for all

Viewers:

Protecting data in a shared spreadsheet provides you with in-depth training on Business. Taught by David Rivers as part of the Office 2013 New Features

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