Home >

On this page

AX2300

Control Sheets

Every Axiom file has a Control Sheet (tab name: Control_Sheet). The Control Sheet contains settings for each sheet in the workbook.

Control Sheet settings define the following:

  • Save to database options
  • Sheet display and protection options
  • Sheet filters
  • Axiom queries

Control Sheet settings can be configured manually on the sheet, or you can use the Sheet Assistant task pane to edit most common settings. Some settings, such as save-to-database settings, are only available on the Control Sheet.

Most sheets in an Axiom file are set up on the Control Sheet. However, if a sheet does not need to use any of these Axiom file features, then that sheet does not need to be configured on the Control Sheet.

Accessing the Control Sheet

The Control Sheet is hidden by default in all files, by use of the Hide Control Sheet on open property on the Control Sheet. By default, this property is set to On (including for older Control Sheets where the setting is not present).

If Hide Control Sheet on open is set to Off, then the user's security permissions control whether the Control Sheet is visible or hidden by default:

  • If the user is an administrator or has the Sheet Assistant permission for the file, then the Control Sheet is visible.
  • Otherwise, the Control Sheet is hidden.

If the Control Sheet is hidden, and the workbook is protected, users with the appropriate permissions can unhide it as follows:

  • Users with access to the Sheet Assistant can double-click a property name in the Sheet Assistant to be taken to the corresponding property in the Control Sheet. For example, you can double-click Query Name to be taken to the name of the Axiom query on the Control Sheet. This will also unhide the Control Sheet if it is hidden.

  • Users with permission to unprotect workbooks can manually unprotect the file and unhide the sheet. Administrators can also use the Show Everything feature on the Axiom Designer ribbon tab.

NOTE: In plan files, the Control Sheet is always hidden by default and the workbook is always protected, regardless of the Control Sheet settings.

See also