To set options for the administrative and other advanced tasks as described inTable 9, click Options on the Smart View ribbon, and then select Advanced in the left panel.
Table 9. Advanced Options
| Option | |
|---|---|
| General | |
| Shared Connections URL | Specify a default URL for all connections. Use the following syntax: http://<server>:19000/workspace/SmartViewProviders Note: This field must contain an EPM Workspace URL for Smart View online help to be available. |
| Number of Undo Actions | The number of Undo and Redo actions permitted on an operation (0 through 100). See Using Undo and Redo . |
| Number of Most Recently Used Items | The number, 15 or fewer, of your most recently used connections to be displayed on Smart View Home and the Open menu on the Smart View ribbon. |
| Delete All MRU Items | Delete all items in your most recently used list, including those that are pinned to the list. |
| Logging | |
| Log Message Display | All error, warnings, and informational messages from the connected data source are displayed when they occur, but you can choose which of these message levels to record in a log file. Select a message level to display and record: For information about enhanced logging capabilities, see Enabling Advanced Logging |
| Route message to files | Save log messages in a file. Click the ellipsis button to change the location of the log file. |
| Clear Log File on Next Launch | Clear the log file starting with the next log message generation, which will be seen after Excel is closed. |
| Display | |
| Adjust Column width | Adjust column widths to fit cell contents automatically. |
| Language | Select a language in which to display Smart View. You must restart the Office application when you change languages. Default is the language specified when Smart View was installed. |
| Display Smart View Short Cut Menus Only | Display only Smart View menu items on shortcut menus. Otherwise, shortcut menus display both Excel and Smart View items. |
| Disable Smart View in Outlook | Disable Smart View in Outlook if you do not want to use Smart View task lists in Outlook |
| Enable Ribbon Context Changing | Display the active data provider ribbon automatically after you use a button on the Smart View ribbon. |
| Disable options that are not valid for the active connection | Disable options in the Options dialog box that are not valid for the active connection. |
| Compatibility | |
| Reduce Excel File Size | Compress the metadata maintained in Excel files that contain Smart View workbooks |
| Improve Metadata storage | Enable workbooks saved in Smart View 9.3.1.0.x or earlier or saved in Office 2000 to be opened. See Importing Metadata into Copied Worksheets. |
| Refresh Selected Functions and their dependents | Execute dependent functions on the same sheet before executing the selected functions. |
| Performance | |
| Enhanced Query Performance | Enable faster performance during queries by directing Smart View not to maintain comments and formulas when you perform such operations as zooming. When you select this option, comments and formulas are not deleted from the original worksheet, but they are not carried through operations on the sheet. |