xxix
Contents
Controlling the advanced sharing settings ...............................................................632
Tracking changes ...........................................................................................632
Updating changes ..........................................................................................633
Resolving conflicting changes between users .................................................633
Controlling the Include in Personal View settings ..........................................633
Tracking Workbook Changes ...........................................................................................633
Turning Track Changes on and off ..........................................................................633
Reviewing the changes ............................................................................................635Chapter 31: Protecting Your Work . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 637
Types of Protection ...........................................................................................................637
Protecting a Worksheet .....................................................................................................638
Unlocking cells........................................................................................................639
Sheet protection options..........................................................................................640
Assigning user permissions......................................................................................641
Protecting a Workbook .....................................................................................................641
Requiring a password to open a workbook ..............................................................641
Protecting a workbook’s structure ...........................................................................643
Protecting a workbook’s windows ...........................................................................644
VB Project Protection ........................................................................................................644
Related Topics ..................................................................................................................645
Saving a worksheet as a PDF file .............................................................................645
Marking a workbook final .......................................................................................646
Inspecting a workbook ............................................................................................646
Using a digital signature ..........................................................................................646
Getting a digital ID ........................................................................................647
Signing a workbook.......................................................................................647Chapter 32: Making Your Worksheets Error-Free . . . . . . . . . . . . . . . . . . 649
Finding and Correcting Formula Errors ............................................................................649
Mismatched parentheses .........................................................................................650
Cells are filled with hash marks ...............................................................................651
Blank cells are not blank .........................................................................................651
Extra space characters .............................................................................................652
Formulas returning an error ....................................................................................653
#DIV/0! errors ...............................................................................................653
#N/A errors ...................................................................................................654
#NAME? errors ..............................................................................................655
#NULL! errors ...............................................................................................655
#NUM! errors ................................................................................................655
#REF! errors ..................................................................................................656
#VALUE! errors .............................................................................................656
Absolute/relative reference problems .......................................................................657
Operator precedence problems ...............................................................................657
Formulas are not calculated.....................................................................................658
Actual versus displayed values.................................................................................65802_474877-ftoc.indd xxix02_474877-ftoc.indd xxix 3/29/10 11:34 PM3/29/10 11:34 PM