Theft-Proof Data^®

It is rarely necessary to TP all your information. You only need to protect cells that contain personal or confidential information, such as account numbers, SSNs, addresses, passwords, etc. Generally there is no need to TP formula cells, as TP'd data that they contain will automatically be cleared as well.

No. TP'd cells are only available when you are online. For most applications, these cells are typically the ones that you are least likely to want to review, model, or change.

Nothing!

They can, however presently TP status will be lost when they are pasted. It would have the same effect as retyping the information into the target document. In future releases they will remain protected in the program associated by that file type. If that program is TPD-enabled then anyone with Permission will be able to access the cells. If they do not have permission or the program is not TPD-enabled then the protected field will remain blank or will contain a random pointer. Note that these fields can in turn be further copied into any other file type and will remain protected unless used by a TPD-enabled program and a person with at least Read permissions.

Select the entire sheet by clicking on the button at the upper left of the sheet, then right click and select "View Permissions". Permissions will be displayed for all the TP'd cells on the sheet, then click OK. Only TP'd cells will remain selected.

You need to go to www.TheftProofData.com and follow the instructions to reset your password.

Simple – just use the un-Theft-Proof command and store your file on your PC.

The first person to TP a cell is that cell's owner. If no permissions are given then he or she is the only person who can access this protected cell. The owner has the right to give access to other people or groups of people:

A copy of a cell exists whenever it is copied to another cell on the same or different workbook, or when a new copy of the workbook is saved, copied or backed up. In any case, all copies of a cell share the same permissions.

This right should be granted rarely, as anyone with this ability can remove or add anyone to/from the permission list. A key and powerful feature is that anyone with Set permissions will control all copies of that cell, regardless of how many times it is saved, copied or even updated. This means that the owner, or anyone to whom Set permission has been granted, can change or revoke access to all of the copies of the cell, regardless of where they are or when they were saved. Note that the original owner can never be removed or changed. The original owner who TP's cells has full, irrevocable rights to Read, Update and Set others to read, update and themselves allow others to access these cells.

The person who first TP's a cell is the cell Owner. The Owner has irrevocable permission to do do whatever he or she wants, including give Permissions to other people.

Use View Permissions to see all of the people or Groups that have Permission for the cells you have selected.

Use Edit Permissions to manage permissions for the cells that you have selected. Note that nothing is permanent until you save your workbook. Any changes you make apply to all versions (copies) of the cells. So if you have sent out copies of the file, the permissions for those copies change at the same time.

Groups may contain individuals and other groups, so assigning permission to a group enables all members of the group to have Read, Update, and Set access. Permissions are checked at run-time so changes to groups are retroactively applied. This means that if the group members change over time the access will change to match the current group, even for old copies of TP'd data. It should be noted that while groups can be powerful and useful, their use delegates some permissions control to whomever is administering the group members. Contact your system administrator to set up and maintain groups or for more details on groups.

There are several methods to accomplish this, depending on the circumstance.

If you are going to be TPing a number of cells, after you set up one with the permissions you want for all of them, you can check this box before you click "OK". From then on during this Excel session whenever you TP a cell it will start with the most recent Set Default permissions. Note: If you have multiple cells selected and some of the check marks are grey, ONLY the permissions marked with black will be included in the new Default.

After a cell was TP'd it was copied and pasted to other cell locations. When this is done, these cells share the same permissions. If you want these cells to have individual permissions then first un-TP the cells and TP them again and assign new permissions. You can TP and set permissions as a group and they will still have individual permissions, but it is only when you copy and paste a TP'd cell, or save multi copies of a workbook, does it share permissions with the original cell.

Whenever you copy/paste TP'd cells the new cells will have the same permissions control as the originals. Instead of copying/pasting the cells you should just copy/paste the formatting, then TP the cell(s) that you will be responsible for. From that point on, you are the owner and have control over every copy made from then on.

You only had Read permission for that cell. Excel will let you change the cell contents but TPD will not permit you to save these changes.

You can safely fill the cells with your own data to make sure that your formatting and charts are set up properly. Any changes that you make for TP'd cells will not be saved unless you have Update permission.

TP'ing a cell protects the data in that copy of the Workbook. Your colleague has a different copy and so it contains different, but also TP'd, data. For her to see your change you will need to send the workbook to her and she will have to have permission to see it.

You highlight the entire sheet (or any selection you like) and click "View Permissions". Every person that has permission for even one cell in the selection will be shown. If a user or group has a particular permission for every cell in the selection the check mark will be black. If permission exists for only some of the cells, then the check is grey. An empty box indicates the user does not have that permission for any cells in the selection.

While in Parallel Mode (PM) the system must do some sheet operations to ensure the PM data is set correctly, and Excel interprets this as an abort in the save process. Simply restart the close procedure.

If the formulas have been retrieved (you have Read permission) and the result is not filled in then it is likely you have the Excel Calculation setting at Manual. Press F9 to recalculate.

Pivot Tables in Excel are a representation of data, not the data itself. Theft-Proofing only works on the source data. If your source data is contained on an Excel worksheet you can Theft-Proof the original data (but not column headings) on that worksheet, and then your information will be properly Theft-Proofed. If the data comes from an external source, it must be Theft-Proofed at the source with TPD Enterprise.

When TP'd, TPD Office saves cell formulas exactly as they were. If you move the source data without the formula in place (TPD Office hasn't retrieved it) the formula cannot be updated. In general, formulas do not need to be TP'd, only source data.