Leading the way in Microsoft Office Development

Switch on Track Changes

To activate the track changes in a workbook select (Tools > Track Changes > Highlight Changes).

Select the "Track Changes while editing" checkbox.

SS

Protecting the Change History in a Shared Workbook

It is possible to protect the change history of a workbook when you are using Track Changes.

If you are currently sharing a workbook and you are using the Track Changes feature then you may want to protect the changes made to a shared workbook.

This can be done by selecting (Tools > Protection > Protect Shared Workbook) to display the Protect Shared Workbook dialog box.

If the workbook is not currently being shared then you can select (Tools > Protection > Protect and Share Workbook) to display an identical dialog box. Your workbook will automatically be shared.

Sharing with track changes - This means that no one in your workgroup can turn off the track changes directly when using the workbook.

Password - Without a password anyone would be able to turn the protection off by selecting (Tools > Protection > Unprotect Shared Workbook). This must be done when the workbook is not currently being shared.

Select the "Sharing with track changes" checkbox and enter a password.

The quickest way to set up Tracked Changes in a workbook is to select (Tools > Protection > Protect and Share Workbook).

If you want to ensure that every change is documented you should protect the shared workbook.

Select "Sharing with track changes" enter a password and press OK.

You will be asked to confirm the password.

This will ensure that no-one can temporarily switch the track changes off when making any modifications to the workbook.

You must protect the workbook before the workbook is saved in shared mode.

Once the workbook has been protected with a password and has been resaved in shared mode, entering the password will turn off the protection as well as removing the workbook from shared mode.