Advanced Options

Set Advanced Options for administrative and other advanced tasks.

Options in the Advanced tab are global options that apply to the entire current workbook, including new sheets added to the current workbook, and become the default for all existing and new workbooks.

The Advanced tab of the Options panel is always available. You can access the Advanced tab before performing operations, such as performing ad hoc, opening a form, setting the active connection for the sheet, or setting the connection for functions.

To set advanced options:

  1. In the Smart View ribbon, click the Options button, Options button, to launch the Options panel.
  2. In the Options panel, select the Advanced tab.
  3. Make selections in the Advanced tab as described in Advanced Options.
  4. Optional: Continue making changes to options in the Data, Members, or Formatting tabs.
  5. Click X button to close in the top right corner to close Options.

    Note:

    Clicking the Apply to All Sheets button is not required. The options that appear in the Advanced tab always apply to all sheets, regardless of whether you click Apply to All Sheets.

    However, if you have made changes in the Data, Members, or Formatting tabs, you must click Apply to All Sheets in order to apply those changes to all sheets in the workbook.

Advanced Options

Table 6-1 Advanced Options

Option Description
General General
Number of Undo Actions

Set the number of Undo and Redo actions permitted on an operation (0 through 100).

See Using Undo and Redo.

Save Current Options as Default

Select to save your modified option selections in the Data, Member, and Formatting tabs. After saving, your options selections become the default for any new content that you import from a data source.

Note:

Changes made in the Advanced tab automatically become the default settings. You do not need to select the Save Current Options as Default command to save the Advanced options.

Logging Logging
Enable diagnostics Select to enable diagnostics.
Enable client logging Select to enable client logging.
Show Log Click to display the Smart View log in a separate window. You can view the log in the window or download it to a file.
Clear Storage Click to clear the storage cache. The storage cache include any previously-selected options on the Advanced tab, as well as on the Data, Members, and Formatting tabs.
User-Defined Function User-Defined Function
Missing Label Specify a value for missing data in user-defined functions.