Page 496 - Excel 2013 All-in-One For Dummies

478 Workbook Sharing 101
9. Click the OK button to close the Highlight Changes dialog box.
As soon as Excel closes the Highlight Changes dialog box, an alert dialog box appears, telling you that Excel will now save the workbook and asking you if you want to continue.
10. Click the OK button in the Microsoft Excel alert dialog box to save the workbook with the change tracking and file sharing settings.
After you turn on change tracking in a shared workbook, Excel highlights the following changes:
✦ Changes to the cell contents, including moving and copying the contents to new cells in the worksheet
✦ Deletion of the cell contents
✦ Insertion of new rows, columns, or cells in a worksheet
When change tracking is turned on in a workbook, the program does not, however, highlight any of these changes:
✦ Formatting changes made to the cells
✦ Hidden or unhidden rows and columns in the worksheet
✦ Renamed sheet tabs in the workbook
✦ Insertion or deletion of a worksheet in the workbook
✦ Comments added to the cells
✦ Changes to cell values resulting from the recalculation of formulas or to cells whose values depend upon those formulas
In highlighting changes you make to the shared workbook, Excel draws a thin line (in another color — usually blue) around the borders of the cell, while at the same time placing a triangle of the same color in the cell’s upper-left corner. When you position the thick white-cross mouse or Touch pointer on a highlighted cell, Excel displays a comment indicating the change made to the cell along with the date and time it was made and who made it, as shown in Figure 3-8.
When you turn on change tracking, you also necessarily turn on file shar- ing, and when file sharing is in effect, you can’t make certain kinds of edit- ing changes. For a complete list of these changes, refer back to the section, “Workbook Sharing 101,” earlier in this chapter.