Setting Smart View Options

Set options for displaying data, members, formatting, and advanced settings using the Smart View Options.

In Smart View, you can set options at two levels — Global and Sheet.

Global Options

Global options apply to the entire current spreadsheet, including any new sheets added to the current spreadsheet, and to spreadsheets that are created later. Changes to global options also affect existing sheets and spreadsheets.

The options that appear on the Advanced tab of the Options dialog are global options. You can access global options from an empty sheet also.

Sheet Options

Sheet options are specific to the sheet for which they are set. The options that appear on the Data, Members, and Formatting tabs of the Options dialog are sheet options.

You can also save sheet options as default options for any new content that you import from a data source. Once you set your required options in the Data, Members, and Formatting tabs, go to the Advanced tab and click Save Current Options as Default.