Datasheet Tab in Options Window

Use this tab to specify the revision history and Sheet Of calculation settings.

Set the number of revisions that appear in the revision history list by entering a number in the Maximum Number of Revisions in History List field.

Specify which fields are to be available for the entry and display of information relating to revisions by checking or unchecking the Use checkboxes in the Name Captions section as required.

To change a field name caption, enter the required text in the Caption field. If no text is entered into the Caption fields and the Use checkbox is checked, the default name shown in the Field Name column will be used.

The properties of each datasheet include an "of" value. For example, a datasheet may be sheet 1 of 2. If this value (e.g. "2") is to be calculated either by simply totaling the number of sheets with the same datasheet number, the Use MAX sheet No. as value for Sheet Of checkbox should be unchecked.

If the maximum sheet number (i.e. the highest) is to be used as the basis for this calculation, this checkbox should be checked. In other words, when the lowest number is more than one, then the sheets with lower numbers that are implied to exist are taken into account.

If this setting is changed, a message will be displayed when preferences are saved asking whether or not sheet numbers for existing datasheets should be recalculated. If No is clicked, the change will only be applied to datasheets subsequently created or updated.

Note:
To save any changes and close the Options window, click Save. Click Cancel to close the window without any changes.