OC Preferences – Advanced


Option NameOption Description
Enable the trace logCheck this box to turn tracing on.  Tracing seriously reduces performance, so only enable this option to perform troubleshooting.  Office Connector automatically displays a warning if you forget and leave this setting on.
Default to "Save data with report" on new workbooksThis check box controls the default value for Save data with report on new workbooks that you create using this computer.
Prompt when opening un-optimized workbooksCheck this box to cause Office Connector to prompt you regarding workbook optimizations when opening older workbooks.  If you decline to optimize a workbook, Office Connector offers to turn the prompts off.  Checking this box is the only way to restore those prompts once turned off.

Clear this box to prevent Office Connector from prompting you to optimize older workbooks.
Do not try to reuse login credentialsCheck this box to force Office Connector to prompt for login credentials for each new data folder you open during a given Excel session.
Display technical support toolbar buttonsCheck this box to display shortcuts to certain menu items that are useful for troubleshooting.
Show SQL Monitor windowCheck this box to turn the SQL Monitor window on.  The window will automatically pop up the next time a workbook function is evaluated.
Check for updates nowClick this link to check the web site for updates.  You can also check for updates under the Office Connector Help menu or by going to the Event 1 web site.
OKClick OK to save your changes and dismiss the window.
CancelClick Cancel to discard your changes and dismiss the window.
HelpClick Help to display the web help for the associated screen.