XL2000: Borders Appear in Printed Workbook Using Track Changes (211891)

RESOLUTION

Method 1: Clear the "Highlight Changes on Screen" Check Box

To prevent borders from appearing around cells when you share the workbook with unsaved changes, clear the Highlight changes on screen check box. To do this, follow these steps:

1. On the Tools menu, point to Track Changes, and then click Highlight Changes.
2. In the Highlight Changes dialog box, click to clear the Highlight changes on screen check box.
3. Click OK.

By clearing the Highlight changes on screen check box, the changed cells are not highlighted (marked) on the worksheet, and the changed cells do not appear with borders in print preview or in the printed document. When changed cells are marked on the worksheet, borders appear in print preview or in the printed document. You cannot set these two options independently.

Method 2: Click "Since I Last Saved"

If you click Since I last saved in the When list (in the Highlight Changes dialog box), and then save the workbook, all modifications are saved. After you save the file, the cells that were marked as changed cells do not appear with a border. To use this method, follow these steps:

1. On the Tools menu, point to Track Changes, and then click Highlight Changes.
2. In the When list, click Since I last saved.
3. Click OK.
4. On the File menu, click Save.

NOTE: If you point to Track Changes on the Tools menu, and then click Accept or Reject Changes, you are prompted to save the workbook before you can accept or reject the changes. After you save the workbook, the changed cells do not appear with a border.