<workbookPr> (Workbook Properties)

This element defines a collection of workbook properties.

example:
<workbookPr date1904="1" showObjects="none" saveExternalLinkValues="0"
  defaultThemeVersion="123820"/>

Parent Elements

<workbook>3.2.27)

Attributes

Description

<allowRefreshQuery> (Allow Refresh Query)

Specifies a boolean value that indicates whether the application will refresh query table in this workbook.

A value of on, 1, or true indicates the application will refresh query tables when the workbook is loaded.

A value of off, 0, or false indicates the application will not refresh query tables.

The default value for this attribute is false.

The possible values for this attribute are defined by the XML Schema boolean datatype.

<autoCompressPictures> (Auto Compress Pictures)

Specifies a boolean value that indicates the application automatically compressed pictures in the workbook.

A value of on, 1, or true indicates the application automatically compresses pictures of the workbook. When a picture is compresses, the application:

  • Reduces resolution (to 96 dots per inch (dpi) for Web and 200 dpi for print), and unnecessary information is discarded.

  • Discards extra information. For example, when a picture has been cropped or resized, the "hidden" parts of the picture are stored in the file.

  • Compress the picture, if possible.

A value of off, 0, or false indicates the application does not compress pictures in this workbook.

The default value for this attribute is true.

The possible values for this attribute are defined by the XML Schema boolean datatype.

<backupFile> (Create Backup File)

Specifies a boolean value that indicates whether the application creates a backup of the workbook on save.

A value of on, 1, or true indicates the application creates a backup of the workbook on save.

A value of off, 0, or false indicates the application does not create a backup.

The default value for this attribute is false.

The possible values for this attribute are defined by the XML Schema boolean datatype.

<checkCompatibility> (Check Compatibility On Save)

Specifies a boolean value that indicates whether the application checks for compatibility when saving this workbook to older file formats.

A value of on, 1, or true indicates the application performs a compatibility check when saving to legacy binary formats.

A value of off, 0, or false indicates the application does not perform a compatibility check when saving to legacy binary formats.

The default value for this attribute is false.

The possible values for this attribute are defined by the XML Schema boolean datatype.

<codeName> (Code Name)

Specifies the codename of the application that created this workbook. Use this attribute to track file content in incremental releases of the application.

The possible values for this attribute are defined by the XML Schema string datatype.

<date1904> (Date 1904)

Specifies a boolean value that indicates whether the date systems used in the workbook starts in 1904.

A value of on, 1, or true indicates the date system starts in 1904.

A value of off, 0, or false indicates the workbook uses the 1900 date system, where 1/1/1900 is the first day in the system.

The default value for this attribute is false.

The possible values for this attribute are defined by the XML Schema boolean datatype.

<defaultThemeVersion> (Default Theme Version)

Specifies the default version of themes to apply in the workbook.

The value for <defaultThemeVersion> depends on the application. SpreadsheetML defaults to the form [version][build], where [version] refers to the version of the application, and [build] refers to the build of the application when the themes in the user interface changed.

The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

<filterPrivacy> (Filter Privacy)

Specifies a boolean value that indicates whether the application has been inspected the workbook for personally identifying information (PII). If this flag is set, the application warns the user any time the user performs do an action that will insert PII into the document. For example, inserting a comment might inserts the user's name.

A value of on, 1, or true indicates the application will warn the user when they insert PII into the workbook.

A value of off, 0, or false indicates the application will not warn the user when they insert PII into the workbook; the workbook has not been inspected for PII.

The default value for this attribute is false.

The possible values for this attribute are defined by the XML Schema boolean datatype.

<hidePivotFieldList> (Hide Pivot Field List)

Specifies a boolean value that indicates whether a list of fields is shown for pivot tables in the application user interface.

A value of on, 1, or true indicates a list of fields is show for pivot tables.

A value of off, 0, or false indicates a list of fields is not shown for pivot tables.

The default value for this attribute is false.

The possible values for this attribute are defined by the XML Schema boolean datatype.

<promptedSolutions> (Prompted Solutions)

Specifies a boolean value that indicates whether the user has received an alert to load Smart Document components.

A value of on, 1, or true indicates the user received an alert to load SmartDoc.

A value of off, 0, or false indicates the user did not receive an alert.

The default value for this attribute is false.

The possible values for this attribute are defined by the XML Schema boolean datatype.

<publishItems> (Publish Items)

Specifies a boolean value that indicates whether the publish the workbook or workbook items to the application server.

A value of on, 1, or true indicates that workbook items are published.

A value of off, 0, or false indicates that the workbook is published.

The default value for this attribute is false.

The possible values for this attribute are defined by the XML Schema boolean datatype.

<refreshAllConnections> (Refresh all Connections on Open)

Specifies a boolean value that indicates whether the workbok shall refresh all the connections to data sources during load.

The default value for this attribute is false.

The possible values for this attribute are defined by the XML Schema boolean datatype.

<saveExternalLinkValues> (Save External Link Values)

Specifies a boolean value that indicates whether the application will cache values retrieved from other workbooks via an externally linking formula. Data is cached at save.

A value of on, 1, or true indicates data from externally linked formulas is cached. A supporting part is written out containing a cached cell table from the external workbook.

A value of off, 0, or false indicates data from externally linked formulas is not cached.

The default value for this attribute is true.

The possible values for this attribute are defined by the XML Schema boolean datatype.

<showBorderUnselectedTables> (Show Border Unselected Table)

Specifies a boolean value that indicates whether a border is drawn around unselected tables in the workbook.

A value of on, 1, or true indicates borders are drawn around unselected tables.

A value of off, 0, or false indicates borders are not drawn around unselected tables.

The default value for this attribute is true.

The possible values for this attribute are defined by the XML Schema boolean datatype.

<showInkAnnotation> (Show Ink Annotations)

Specifies a boolean value that indicates whether the book shows ink annotations.

A value of on, 1, or true indicates that ink annotations are shown in the workbook.

A value of off, 0, or false indicates that ink annotations are not shown in the workbook.

The default value for this attribute is true.

The possible values for this attribute are defined by the XML Schema boolean datatype.

<showObjects> (Show Objects)

Specifies how the application shows embedded objects in the workbook.

This attribute it optional.

The default value for this attribute is "all."

The possible values for this attribute are defined by the ST_Objects simple type (§3.18.50).

<showPivotChartFilter> (Show Pivot Chart Filter)

Specifies a boolean value that indicates whether filtering options are shown for pivot charts in the workbook.

A value of on, 1, or true indicates filtering options shall be shown for pivot charts.

A value of off, 0, or false indicates filtering options shall not be shown.

The default value for this attribute is false.

The possible values for this attribute are defined by the XML Schema boolean datatype.

<updateLinks> (Update Links Behavior)

Specifies how the application updates external links when the workbook is opened.

The default value for this attribute is userSet.

The possible values for this attribute are defined by the ST_UpdateLinks simple type (§3.18.88).

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_WorkbookPr">
	<attribute name="date1904" type="xsd:boolean" use="optional" default="false"/>
	<attribute name="showObjects" type="ST_Objects" use="optional" default="all"/>
	<attribute name="showBorderUnselectedTables" type="xsd:boolean" use="optional" default="true"/>
	<attribute name="filterPrivacy" type="xsd:boolean" use="optional" default="false"/>
	<attribute name="promptedSolutions" type="xsd:boolean" use="optional" default="false"/>
	<attribute name="showInkAnnotation" type="xsd:boolean" use="optional" default="true"/>
	<attribute name="backupFile" type="xsd:boolean" use="optional" default="false"/>
	<attribute name="saveExternalLinkValues" type="xsd:boolean" use="optional" default="true"/>
	<attribute name="updateLinks" type="ST_UpdateLinks" use="optional" default="userSet"/>
	<attribute name="codeName" type="xsd:string" use="optional"/>
	<attribute name="hidePivotFieldList" type="xsd:boolean" use="optional" default="false"/>
	<attribute name="showPivotChartFilter" type="xsd:boolean" default="false"/>
	<attribute name="allowRefreshQuery" type="xsd:boolean" use="optional" default="false"/>
	<attribute name="publishItems" type="xsd:boolean" use="optional" default="false"/>
	<attribute name="checkCompatibility" type="xsd:boolean" use="optional" default="false"/>
	<attribute name="autoCompressPictures" type="xsd:boolean" use="optional" default="true"/>
	<attribute name="refreshAllConnections" type="xsd:boolean" use="optional" default="false"/>
	<attribute name="defaultThemeVersion" type="xsd:unsignedInt" use="optional"/>
</complexType>