Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

2.1.808 Part 4 Section 3.10.1.67, pivotCacheDefinition (PivotCache Definition)

a. The standard doesn't specify maxLength for @refreshedBy.

In Office the maxLength for @refreshedBy is 255.

b. The standard doesn't specify any restrictions for @backgroundQuery.

In Office @backgroundQuery shall be 0 for non-external data sources.

c. The standard states that on and off are valid values of the backgroundQuery attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

d. The standard states that on and off are valid values of the enableRefresh attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

e. The standard states that on and off are valid values of the invalid attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

f. The standard states that on and off are valid values of the optimizeMemory attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

g. The standard states that on and off are valid values of the saveData attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

h. The standard states that on and off are valid values of the upgradeOnRefresh attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

i. The standard states that on and off are valid values of the tupleCache attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

j. The standard does not specify any restrictions for the optimizeMemory attribute.

In Office, the optimizeMemory attribute must be 0 or false for non-external and non-ODBC data sources.

k. The standard states that on and off are valid values of the refreshOnLoad attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

l. The standard does not specify any restrictions for the refreshedVersion attribute.

In Office, the refreshedVersion attribute shall not be less than the minRefreshableVersion attribute.

m. The standard does not specify any restrictions for the id attribute .

In Office, the id attribute must not be empty if the saveData attribute is 1 and the invalid attribute is 0.

n. The standard does not define application defined behavior when the missingItemsLimit attribute is not present.

If this number is not specified, Office sets the threshold automatically based on the number of items.

o. The standard does not define a relation between this @tupleCache and the tupleCache child element.

In Office, if @tupleCache has a value of 0, then pivotCacheDefinition shall not contain tupleCache element.

p. The standard does not place any restrictions on the value of the backgroundQuery attribute with respect to connection element.

Office requires the backgroundQuery attribute match the value of background on the related connection element.

Show:
© 2016 Microsoft