Spreadsheet Audit Log Settings

Ribbon bar. Select the Tools tab. In the Tools group, click Audit Trail and from the menu, select Settings to display the Spreadsheet Audit Log Settings dialog box, which is used to specify the settings for the spreadsheet audit log.

Classic menus. From the Tools - Audit Trail submenu, select Settings to display the Spreadsheet Audit Log Settings dialog box, which is used to specify the settings for the spreadsheet audit log.

Enable audit trail logging. Select this check box to begin audit trail logging for the current spreadsheet. Once logging is enabled, the log can be turned off again by clearing this check box. If the system is running under Statistica Enterprise, only a user with Administrator permissions can change the log file settings. Also, if the logging feature is locked (Tools - Locking), you must unlock the logging feature before the log service can be stopped or started. See Lock Spreadsheet for more details.

Require users to enter reason comments for each change. Select this check box to require users to explain each change made to the spreadsheet. When this check box is selected and a change is made to the spreadsheet, the Enter reason for change dialog box is displayed. The user must enter a comment about the change and click OK before the change will be made. The comment is stored and displayed in the Spreadsheet Audit Log Viewer.

Truncate log. Click this button to truncate the spreadsheet log and delete all existing entries. You will be prompted to confirm this action before the current entries are deleted. Once the log is truncated, the truncate action will be recorded in the newly truncated log file.

OK. Click this button to apply the new log settings.

Cancel. Click this button to exit this dialog box without changing the log settings.