This folder contains policy settings for managing Live Preview and for specifying whether to show all open workbooks on the taskbar, the initial number of worksheets in a workbook, standard fonts, and hiding the Mini Toolbar. The Popular folder is located in the User Configuration\Administrative Templates\Microsoft Office Excel 2007\Excel Options folder in Group Policy Object Editor.

This folder contains policy settings for checking or clearing the R1C1 reference style option. R1C1 reference style is used for computing row and column positions in macros. The Formulas folder is located in the User Configuration\Administrative Templates\Microsoft Office Excel 2007\Excel Options folder in Group Policy Object Editor.

This folder contains policy settings for making an adjacent row or column part of the table that you are currently working in, and for enabling the Replace as You Type option for hyperlinks. The Proofing folder is located in the User Configuration\Administrative Templates\Microsoft Office Excel 2007\Excel Options folder in Group Policy Object Editor.

This folder contains policy settings for controlling the following options:

• Default working folder location.

• Format for Save Excel files, such as: Excel Workbook (.xlsx), Excel Macro-Enabled Workbook (.xlsm), Excel Binary Workbook (.xlsb), Web Page (*.htm, *.html), Excel 97- Excel 2003 Workbook (.xls), and Excel 5.0/95 Workbook (.xls). For information about setting the default file save options for Microsoft Office Excel 2007, see Using Group Policy to set default file save options.

• Prompting for workbook properties.

• Saving AutoRecover information, AutoRecover time, AutoRecover save location, and AutoRecover delay.

• Disabling the AutoRepublish feature and whether to display the AutoRepublish warning alert.

The Save folder is located in the User Configuration\Administrative Templates\Microsoft Office Excel 2007\Excel Options folder in Group Policy Object Editor.

This folder contains policy settings for Trust Center and Trusted Locations, and other security areas. Administrators can configure the following policy settings:

• Disable all application add-ins. Add-ins are enabled by default. When this policy setting is enabled, add-ins are disabled. Users are not notified that add-ins are disabled.

• Disable Trust Bar Notification for unsigned application add-ins. When this policy setting is enabled, Office applications silently disable any DLL that contains an application add-in which does not have a digital signature.

• Require that application add-ins are signed by Trusted Publisher. When this policy setting is enabled, Office applications check the digital signature on the .DLL that contains an application add-in. The applications display a security notification if the DLL is unsigned or the DLL is signed by a publisher's certificate that is not in the Trusted Publishers list.

• Store macro in Personal Macro Workbook by default. When macro recording is started, the user is asked whether the macro should be stored in this workbook, in a new workbook, or in a personal macro workbook. This policy changes the default setting.

• Suppress High Security macro alert for unsigned Macros. When the security level is set to high, unsigned macros do not run. This setting controls whether or not an alert displays when a macro is blocked from running because it is unsigned.

• Trust access to Visual Basic project. When this setting is enabled, users can use Visual Basic code to change the Visual Basic project that is associated with a workbook (for example, users can programmatically insert a code module).

• VBA Macro Warning Settings. This policy setting allows administrators to configure what notifications display for VBA macros.

• Trusted Locations. This folder contains several policy settings that administrators can use to control the behavior of trusted locations:

  • Allow Trusted Locations not on the computer. By default, trusted locations that are network shares are disabled. However, users can use the Trust Center graphical user interface to select the Allow Trusted Locations on my network check box. Enabling the Allow Trusted Locations not on the computer policy setting disables trusted locations that are network shares and prevents users from selecting the Allow Trusted Locations on my network check box in the Trust Center graphical user interface.

    If this policy setting is set to Disabled and a user attempts to designate a network share as a trusted location, a warning informs the user that the current security settings do not allow the creation of trusted locations with remote paths or network paths. If an administrator designates a network share as a trusted location through Group Policy or by using the OCT and this setting is Disabled, the trusted location is disabled and is not recognized by an application.

  • Disable all trusted locations. By default, trusted locations are enabled. When this setting is set to Enabled, it disables all trusted locations. This includes trusted locations that are created by default during Setup, those created by users through the graphical user interface, or those deployed by using Group Policy. Enabling this setting also prevents users from configuring trusted locations settings in the Trust Center.

  • Trusted Location #1 through Trusted Location #20. These policy settings are used to specify trusted locations for Excel.

  Note:
  During installation, several trusted locations are specified by default. These default trusted locations do not appear in Group Policy Object Editor or in the OCT. For information about default trusted locations, see "Default settings for trusted locations" in Evaluate default security settings and privacy options for the 2007 Office system.

The Security folder is located in the User Configuration\Administrative Templates\Microsoft Office Excel 2007\Excel Options folder in Group Policy Object Editor.

For detailed information about planning and managing Trusted Locations and Trust Center and other security areas for Office 2007, see the following resources:

• Plan trusted locations and trusted publishers settings for the 2007 Office system

• Security policies and settings in the 2007 Office system

• Configure trusted locations and trusted publishers settings in the 2007 Office system

The Advanced folder contains policy settings used for managing Advanced options.

In Excel 2007, many of the less frequently used settings for features such as compatibility, editing, printing, Web options, and saving have been placed in the Advanced category in the Excel Options dialog box. You can see the Advanced settings in the Excel 2007 user interface by clicking the Microsoft Office Button, clicking Excel Options, and clicking Advanced. The settings are organized by feature category.

The Group Policy settings in the Advanced folder are used to control many of the Excel Advanced user interface settings.

For example, the policy settings under the Web Options folder in Group Policy Object Editor are used to set options that specify how Excel data looks and responds when the data is viewed in a Web browser. The policy settings manage the corresponding user interface options on the General tab of the Web Options dialog box.

The Advanced folder is located in the User Configuration\Administrative Templates\Microsoft Office Excel 2007\Excel Options folder in Group Policy Object Editor.

Users can use a query in Excel to retrieve data from corporate databases and files that they want to analyze in Excel. They can also use PivotTables reports to summarize, analyze, and present summary data. Users can specify PivotTable options to control whether to refresh the data when Excel opens the Excel workbook that contains the PivotTable report.

Users can specify options to refresh an external data range automatically when a workbook is opened by using the Connection Properties dialog box in Excel.

Administrators can use the Automatic Query Refresh policy setting to specify how Excel behaves when it opens a file that contains a query or PivotTable that is configured to refresh automatically. Administrators can specify one of the following options:

• Default: Prompt for all workbooks.

• Do not prompt; do not allow auto refresh.

• Do not prompt; allow auto refresh.

Excel workbook data can be stored directly in the workbook or in an external data source, such as a text file, a database, or an Online Analytical Processing (OLAP) cube. A data connection—information that describes how to locate, log in, and access the external data source—is used to connect external data sources to the workbook. The connection information can be stored in the workbook or in a connection file, such as an Office Data Connection (ODC) file (.odc) or a Data Source Name file (.dsn).

Administrators can store a set of connection files within a folder (UNC or URL) on the corporate network, and then publish the location of these connection files to users across the network by using the Connection File Locations policy setting. If this policy setting is set to Enabled, you can make the connection files available to users by specifying a Name and a Location (UNC or URL) value for each set of connections. If no connection file location is specified in this policy setting, the Existing Connections dialog box in Excel has a blank list in the Connection Files on the Network section.

The Data Access Security folder contains the following policy settings for configuring warnings and alerts for data connect and refresh operations:

• OLAP PivotTable connect warning. This setting specifies to warn the user about an OLAP (Online Analytical Processing) data connect operation.

• PivotTable external data connect warning. This setting specifies to warn the user about a connect operation.

• Refresh alert settings. This setting specifies to alert the user about a Refresh Data operation.