1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
|
<html dir="ltr"><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META HTTP-EQUIV="assetid" CONTENT="HV01105118"><META NAME="lcid" CONTENT="1033"><title>PivotTableType complexType</title><link rel="stylesheet" type="text/css" href="office10.css"><script type="text/javascript" language="Javascript" src="ExpCollapse.js"></script><script type="text/javascript" language="JavaScript" src="inline.js"></script></head><body><h1>PivotTableType complexType</h1><p>Contains information on a PivotTable.</p><h2>Type Information</h2><table>
<tr>
<td>
<b class="bterm">Namespace</b>
</td>
<td>urn:schemas-microsoft-com:office:excel</td>
</tr>
<tr>
<td>
<b class="bterm">Schema name</b>
</td>
<td>XML Spreadsheet 2000</td>
</tr>
</table><h2>Elements and Attributes</h2><h3>Child Elements</h3><table>
<tr>
<th>Element</th>
<th>Description</th>
</tr>
<tr>
<td><a href="xeleName_PivotTableType_HV01104762.htm" id="HV01104762" lcid="">Name</a></td>
<td>Specifies the name of the PivotTable.</td>
</tr>
<tr>
<td><a href="xeleDataValueEditing_HV01104519.htm" id="HV01104519" lcid="">DataValueEditing</a></td>
<td>Contains a Boolean value indicating that the user is allowed to edit the cells in the data area of the PivotTable view or report.</td>
</tr>
<tr>
<td><a href="xeleQTSource_HV01104905.htm" id="HV01104905" lcid="">QTSource</a></td>
<td>Describes the properties of the query table on which a PivotTable view or report is based.</td>
</tr>
<tr>
<td><a href="xeleErrorString_HV01104586.htm" id="HV01104586" lcid="">ErrorString</a></td>
<td>Specifies the string to display in cells with errors. Used in conjunction with DisplayErrorString.</td>
</tr>
<tr>
<td><a href="xeleNullString_HV01104812.htm" id="HV01104812" lcid="">NullString</a></td>
<td>Specifies the string to display in cells with no value. Used in conjunction with NoDisplayNullString.</td>
</tr>
<tr>
<td><a href="xelePageFieldOrder_HV01104833.htm" id="HV01104833" lcid="">PageFieldOrder</a></td>
<td>Contains an enumeration indicating how the page fields are laid out when there are multiple PivotFields in the page area.</td>
</tr>
<tr>
<td><a href="xelePageFieldWrapCount_HV01104835.htm" id="HV01104835" lcid="">PageFieldWrapCount</a></td>
<td>Specifies a number indicating how many page fields to display before starting another row or column.</td>
</tr>
<tr>
<td><a href="xeleDisableDrillDown_HV01104541.htm" id="HV01104541" lcid="">DisableDrillDown</a></td>
<td>Contains a Boolean indicating if the user is prevented from drilling down (double clicking) on a PivotItem or aggregate value.</td>
</tr>
<tr>
<td><a href="xeleDisableFieldDialog_HV01104543.htm" id="HV01104543" lcid="">DisableFieldDialog</a></td>
<td>Contains a Boolean indicating if the user is prevented from displaying the PivotField properties dialogs.</td>
</tr>
<tr>
<td><a href="xeleDisableWizard_HV01104546.htm" id="HV01104546" lcid="">DisableWizard</a></td>
<td>Contains a Boolean indicating if the user is prevented from displaying the PivotTable Wizard.</td>
</tr>
<tr>
<td><a href="xeleDisplayErrorString_HV01104549.htm" id="HV01104549" lcid="">DisplayErrorString</a></td>
<td>Causes the ErrorString to be displayed. Used in conjunction with ErrorString.</td>
</tr>
<tr>
<td><a href="xeleNoPreserveFormatting_PivotTableType_HV01104794.htm" id="HV01104794" lcid="">NoPreserveFormatting</a></td>
<td>Contains a Boolean indicating whether the formatting applied by the user to the PivotTable cells is discarded on refresh.</td>
</tr>
<tr>
<td><a href="xeleHasNoAutoFormat_HV01104658.htm" id="HV01104658" lcid="">HasNoAutoFormat</a></td>
<td>Contains a Boolean indicating whether autoformatting has been applied to the PivotTable view. Used in conjunction with AutoFormatName, AutoFormatNumber, AutoFormatBorder, AutoFormatPattern, AutoFormatAlignment and NoAutoFormatWidth.</td>
</tr>
<tr>
<td><a href="xeleSubtotalHiddenPageItems_HV01105008.htm" id="HV01105008" lcid="">SubtotalHiddenPageItems</a></td>
<td>Specifies that data for hidden PivotItems for PivotFields in the data area are not excluded from subtotals.</td>
</tr>
<tr>
<td><a href="xeleNoAutoFormatWidth_HV01104776.htm" id="HV01104776" lcid="">NoAutoFormatWidth</a></td>
<td>Specifies that column widths from the style specified in the AutoFormatName element are not to be applied.</td>
</tr>
<tr>
<td><a href="xeleNoRowGrand_HV01104800.htm" id="HV01104800" lcid="">NoRowGrand</a></td>
<td>Contains a Boolean indicating if no grand totals should be displayed for the PivotTable rows.</td>
</tr>
<tr>
<td><a href="xeleNoColumnGrand_HV01104779.htm" id="HV01104779" lcid="">NoColumnGrand</a></td>
<td>Contains a Boolean indicating if no grand totals should be displayed for the PivotTable columns.</td>
</tr>
<tr>
<td><a href="xeleNoDisplayNullString_HV01104781.htm" id="HV01104781" lcid="">NoDisplayNullString</a></td>
<td>Contains a Boolean indicating whether the custom NULL string should not be displayed. Used in conjunction with NullString.</td>
</tr>
<tr>
<td><a href="xeleNoPrintRepeatItems_HV01104798.htm" id="HV01104798" lcid="">NoPrintRepeatItems</a></td>
<td>Contains a Boolean indicating whether PivotItem names should be repeated at the top of each printed page.</td>
</tr>
<tr>
<td><a href="xelePivotView_HV01104868.htm" id="HV01104868" lcid="">PivotView</a></td>
<td>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</td>
</tr>
<tr>
<td><a href="xeleSelection_PivotTableType_HV01104954.htm" id="HV01104954" lcid="">Selection</a></td>
<td>Contains information about the current PivotTable selection.</td>
</tr>
<tr>
<td><a href="xeleAutoFormatAlignment_PivotTableType_HV01104416.htm" id="HV01104416" lcid="">AutoFormatAlignment</a></td>
<td>Specifies that alignments from the style defined in the AutoFormatName element are to be applied.</td>
</tr>
<tr>
<td><a href="xeleAutoFormatBorder_PivotTableType_HV01104418.htm" id="HV01104418" lcid="">AutoFormatBorder</a></td>
<td>Specifies that border settings from the style defined in the AutoFormatName element are to be applied.</td>
</tr>
<tr>
<td><a href="xeleAutoFormatFont_PivotTableType_HV01104420.htm" id="HV01104420" lcid="">AutoFormatFont</a></td>
<td>Specifies that fonts from the style defined in the AutoFormatName element are to be applied.</td>
</tr>
<tr>
<td><a href="xeleAutoFormatName_PivotTableType_HV01104422.htm" id="HV01104422" lcid="">AutoFormatName</a></td>
<td>Specifies the name of the built-in format to be applied.</td>
</tr>
<tr>
<td><a href="xeleAutoFormatNumber_PivotTableType_HV01104424.htm" id="HV01104424" lcid="">AutoFormatNumber</a></td>
<td>Specifies that number formatting from the style defined in the AutoFormatName element is to be applied.</td>
</tr>
<tr>
<td><a href="xeleAutoFormatPattern_PivotTableType_HV01104426.htm" id="HV01104426" lcid="">AutoFormatPattern</a></td>
<td>Specifies that the pattern from the style defined in the AutoFormatName element is to be applied.</td>
</tr>
<tr>
<td><a href="xeleGrandTotalString_HV01104642.htm" id="HV01104642" lcid="">GrandTotalString</a></td>
<td>Specifies the string to be displayed for grand totals.</td>
</tr>
<tr>
<td><a href="xelePrintSetTitles_HV01104887.htm" id="HV01104887" lcid="">PrintSetTitles</a></td>
<td>Specifies the row and column titles from the PivotTable to be printed (rather than the titles from the spreadsheet).</td>
</tr>
<tr>
<td><a href="xeleMergeLabels_HV01104743.htm" id="HV01104743" lcid="">MergeLabels</a></td>
<td>Specifies that row or column titles that span multiple cells should be merged into a single cell.</td>
</tr>
<tr>
<td><a href="xelePageFieldStyle_HV01104834.htm" id="HV01104834" lcid="">PageFieldStyle</a></td>
<td>Specifies the name of the Excel style to apply to each of the PivotField-PivotItem headers displayed in the page area.</td>
</tr>
<tr>
<td><a href="xelePLExport_HV01104872.htm" id="HV01104872" lcid="">PLExport</a></td>
<td>Contains a Boolean indicating whether the PivotTable was created by the Office Web Components PivotList control.</td>
</tr>
<tr>
<td><a href="xeleImmediateItemsOnDrop_HV01104683.htm" id="HV01104683" lcid="">ImmediateItemsOnDrop</a></td>
<td>Specifies that the PivotTable view is to be immediately updated when new items are dropped into it.</td>
</tr>
<tr>
<td><a href="xeleShowPageMultipleItemLabel_HV01104970.htm" id="HV01104970" lcid="">ShowPageMultipleItemLabel</a></td>
<td>Specifies the text to display for the PivotItem header in the page area when two or more PivotItems, but not all PivotItems, have been selected.</td>
</tr>
<tr>
<td><a href="xeleSmallGrid_HV01104971.htm" id="HV01104971" lcid="">SmallGrid</a></td>
<td>Contains a Boolean indicating if a PivotTable view without a data field should show the small grid, which doesn't have very big drop areas.</td>
</tr>
<tr>
<td><a href="xeleTableStyle_HV01105014.htm" id="HV01105014" lcid="">TableStyle</a></td>
<td>Specifies the name of the Excel style to apply to the main table area of the PivotTable.</td>
</tr>
<tr>
<td><a href="xeleTag_HV01105016.htm" id="HV01105016" lcid="">Tag</a></td>
<td>Specifies a user-defined string that is associated with this PivotTable.</td>
</tr>
<tr>
<td><a href="xeleVacatedStyle_HV01105049.htm" id="HV01105049" lcid="">VacatedStyle</a></td>
<td>Specifies the name of the Excel style to apply to the cells left blank when a PivotTable shrinks during a refresh operation.</td>
</tr>
<tr>
<td><a href="xeleHideTotalsAnnotation_HV01104671.htm" id="HV01104671" lcid="">HideTotalsAnnotation</a></td>
<td>Specifies that asterisks be displayed in subtotals and totals when visual totals are not used in OLAP-based PivotTable views.</td>
</tr>
<tr>
<td><a href="xeleShowCellBackgroundFromOLAP_HV01104968.htm" id="HV01104968" lcid="">ShowCellBackgroundFromOLAP</a></td>
<td>Contains a Boolean value indicating that a PivotTable based on an OLAP source should format the data and aggregate cells in the PivotTable view using the background color from the OLAP source.</td>
</tr>
<tr>
<td><a href="xeleHideDropDowns_PivotTableType_HV01104668.htm" id="HV01104668" lcid="">HideDropDowns</a></td>
<td>Contains a Boolean value indicating whether the drop-down lists for the fields in the PivotTable view should be shown.</td>
</tr>
<tr>
<td><a href="xeleNoViewCalculatedMembers_HV01104811.htm" id="HV01104811" lcid="">NoViewCalculatedMembers</a></td>
<td>Contains a Boolean value indicating whether calculated members should be hidden in a PivotTable view or report.</td>
</tr>
<tr>
<td><a href="xeleVisualTotals_HV01105069.htm" id="HV01105069" lcid="">VisualTotals</a></td>
<td>Indicates that totals should be based on visible data only for OLAP-based PivotTable views.</td>
</tr>
<tr>
<td><a href="xeleLocation_PivotTableType_HV01104722.htm" id="HV01104722" lcid="">Location</a></td>
<td>Specifies the bounding cell reference the PivotTable occupies including the page area.</td>
</tr>
<tr>
<td><a href="xelePLPivotField_HV01104875.htm" id="HV01104875" lcid="">PLPivotField</a></td>
<td>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</td>
</tr>
<tr>
<td><a href="xelePLTotal_HV01104880.htm" id="HV01104880" lcid="">PLTotal</a></td>
<td>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</td>
</tr>
<tr>
<td><a href="xeleDataMember_PivotTableType_HV01104512.htm" id="HV01104512" lcid="">DataMember</a></td>
<td>Specifies whether the data source of a PivotList component is data from Microsoft Excel that was saved to a Web page or data from a Data Source Control component.</td>
</tr>
<tr>
<td><a href="xeleDataAxisEmpty_HV01104509.htm" id="HV01104509" lcid="">DataAxisEmpty</a></td>
<td>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</td>
</tr>
<tr>
<td><a href="xeleDisplayFieldList_HV01104550.htm" id="HV01104550" lcid="">DisplayFieldList</a></td>
<td>Contains a Boolean indicating that the PivotField list window should not be shown.</td>
</tr>
<tr>
<td><a href="xeleNoAutoFit_PivotTableType_HV01104774.htm" id="HV01104774" lcid="">NoAutoFit</a></td>
<td>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</td>
</tr>
<tr>
<td><a href="xeleHeight_HV01104662.htm" id="HV01104662" lcid="">Height</a></td>
<td>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</td>
</tr>
<tr>
<td><a href="xeleWidth_PivotTableType_HV01105075.htm" id="HV01105075" lcid="">Width</a></td>
<td>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</td>
</tr>
<tr>
<td><a href="xeleMaxHeight_HV01104730.htm" id="HV01104730" lcid="">MaxHeight</a></td>
<td>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</td>
</tr>
<tr>
<td><a href="xeleMaxWidth_HV01104732.htm" id="HV01104732" lcid="">MaxWidth</a></td>
<td>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</td>
</tr>
<tr>
<td><a href="xeleMemberExpand_HV01104735.htm" id="HV01104735" lcid="">MemberExpand</a></td>
<td>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</td>
</tr>
<tr>
<td><a href="xeleConnectionString_HV01104496.htm" id="HV01104496" lcid="">ConnectionString</a></td>
<td>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</td>
</tr>
<tr>
<td><a href="xeleCacheDetails_HV01104445.htm" id="HV01104445" lcid="">CacheDetails</a></td>
<td>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</td>
</tr>
<tr>
<td><a href="xeleFieldListTop_HV01104604.htm" id="HV01104604" lcid="">FieldListTop</a></td>
<td>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</td>
</tr>
<tr>
<td><a href="xeleFieldListBottom_HV01104601.htm" id="HV01104601" lcid="">FieldListBottom</a></td>
<td>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</td>
</tr>
<tr>
<td><a href="xeleFieldListRight_HV01104603.htm" id="HV01104603" lcid="">FieldListRight</a></td>
<td>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</td>
</tr>
<tr>
<td><a href="xeleFieldListLeft_HV01104602.htm" id="HV01104602" lcid="">FieldListLeft</a></td>
<td>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</td>
</tr>
<tr>
<td><a href="xelePivotAxis_HV01104862.htm" id="HV01104862" lcid="">PivotAxis</a></td>
<td>Specifies additional information about a PivotTable axis or location.</td>
</tr>
<tr>
<td><a href="xeleVersionUpdateableMin_HV01105064.htm" id="HV01105064" lcid="">VersionUpdateableMin</a></td>
<td>Contains a number indicating the earliest version of Excel that can update this PivotTable view.</td>
</tr>
<tr>
<td><a href="xeleVersionLastUpdate_HV01105059.htm" id="HV01105059" lcid="">VersionLastUpdate</a></td>
<td>Contains a number indicating which version of Excel last updated this PivotTable view.</td>
</tr>
<tr>
<td><a href="xeleVersionRefreshableMin_PivotTableType_HV01105060.htm" id="HV01105060" lcid="">VersionRefreshableMin</a></td>
<td>Contains a number indicating the earliest version of Excel that can refresh this PivotTable view.</td>
</tr>
<tr>
<td><a href="xeleDefaultVersion_HV01104525.htm" id="HV01104525" lcid="">DefaultVersion</a></td>
<td>Contains a number indicating what version of Excel was used to create this PivotTable view.</td>
</tr>
<tr>
<td><a href="xelePivotField_HV01104864.htm" id="HV01104864" lcid="">PivotField</a></td>
<td>Contains information about a PivotField.</td>
</tr>
<tr>
<td><a href="xeleCubeField_HV01104504.htm" id="HV01104504" lcid="">CubeField</a></td>
<td>Contains information about a cube field (a hierarchy in an OLAP-based PivotTable view).</td>
</tr>
<tr>
<td><a href="xeleCalculatedMember_HV01104452.htm" id="HV01104452" lcid="">CalculatedMember</a></td>
<td>Contains information about a calculated member in an OLAP-based PivotTable view or report.</td>
</tr>
<tr>
<td><a href="xeleName_CalculatedMember_HV01104750.htm" id="HV01104750" lcid="">Name</a></td>
<td>Specifies the name of the OLAP calculated member.</td>
</tr>
<tr>
<td><a href="xeleMemberName_HV01104737.htm" id="HV01104737" lcid="">MemberName</a></td>
<td>Specifies a caption (display name) for the custom OLAP calculated member (not used for sets).</td>
</tr>
<tr>
<td><a href="xeleParentUniqueName_CalculatedMember_HV01104850.htm" id="HV01104850" lcid="">ParentUniqueName</a></td>
<td>Specifies a unique name for the parent member of the OLAP calculated member (not used for sets).</td>
</tr>
<tr>
<td><a href="xeleSourceHierarchy_CalculatedMember_HV01104986.htm" id="HV01104986" lcid="">SourceHierarchy</a></td>
<td>Specifies a unique name for the hierarchy with which the OLAP calculated member is associated (not used for sets).</td>
</tr>
<tr>
<td><a href="xeleSourceHierarchyLevel_CalculatedMember_HV01104988.htm" id="HV01104988" lcid="">SourceHierarchyLevel</a></td>
<td>Contains an index of the hierarchy level to which a particular OLAP member property applies. A value of 32767 indicates that the OLAP member property applies to all the levels in a hierarchy.</td>
</tr>
<tr>
<td><a href="xeleFormula_CalculatedMember_HV01104623.htm" id="HV01104623" lcid="">Formula</a></td>
<td>Contains the MDX representation of the formula for the OLAP calculated member.</td>
</tr>
<tr>
<td><a href="xeleSolveOrder_HV01104972.htm" id="HV01104972" lcid="">SolveOrder</a></td>
<td>Specifies where in a sequence of calculations a calculated member will be computed and applied.</td>
</tr>
<tr>
<td><a href="xeleInvalid_HV01104690.htm" id="HV01104690" lcid="">Invalid</a></td>
<td>Contains a Boolean value indicating that the OLAP cube changed in such a way as to invalidate the OLAP calculated member.</td>
</tr>
<tr>
<td><a href="xeleSet_CalculatedMember_HV01104961.htm" id="HV01104961" lcid="">Set</a></td>
<td>Contains a Boolean value indicating that a calculation creates a custom OLAP set.</td>
</tr>
<tr>
<td><a href="xelePTLineItems_HV01104897.htm" id="HV01104897" lcid="">PTLineItems</a></td>
<td>Contains information describing the detailed layout of a PivotTable view.</td>
</tr>
<tr>
<td><a href="xelePTSource_HV01104902.htm" id="HV01104902" lcid="">PTSource</a></td>
<td>Contains information describing the data source of the PivotTable view.</td>
</tr>
<tr>
<td><a href="xelePTFormula_HV01104895.htm" id="HV01104895" lcid="">PTFormula</a></td>
<td>Contains information describing a PivotTable formula that doesn't apply to a whole PivotField or all PivotItems with the same name.</td>
</tr>
<tr>
<td><a href="xelePTFormat_HV01104894.htm" id="HV01104894" lcid="">PTFormat</a></td>
<td>Contains information describing some formatting applied to the PivotTable view.</td>
</tr>
</table><h3>Attributes</h3><p>None.</p><h2>Definition</h2><pre>
<code>
<xsd:complexType name="PivotTableType" >
<xsd:sequence>
<xsd:element name="Name" type="xsd:string">
</xsd:element>
<xsd:element name="DataValueEditing" minOccurs="0">
</xsd:element>
<xsd:element name="QTSource" type="QTSourceType" minOccurs="0">
</xsd:element>
<xsd:element name="ErrorString" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="NullString" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="PageFieldOrder" type="PageFieldOrderType" default="DownThenOver" minOccurs="0">
</xsd:element>
<xsd:element name="PageFieldWrapCount" type="PageFieldWrapCountType" minOccurs="0">
</xsd:element>
<xsd:element name="DisableDrillDown" minOccurs="0">
</xsd:element>
<xsd:element name="DisableFieldDialog" minOccurs="0">
</xsd:element>
<xsd:element name="DisableWizard" minOccurs="0">
</xsd:element>
<xsd:element name="DisplayErrorString" minOccurs="0">
</xsd:element>
<xsd:element name="NoPreserveFormatting" minOccurs="0">
</xsd:element>
<xsd:element name="HasNoAutoFormat" minOccurs="0">
</xsd:element>
<xsd:element name="SubtotalHiddenPageItems" minOccurs="0">
</xsd:element>
<xsd:element name="NoAutoFormatWidth" minOccurs="0">
</xsd:element>
<xsd:element name="NoRowGrand" minOccurs="0">
</xsd:element>
<xsd:element name="NoColumnGrand" minOccurs="0">
</xsd:element>
<xsd:element name="NoDisplayNullString" minOccurs="0">
</xsd:element>
<xsd:element name="NoPrintRepeatItems" minOccurs="0">
</xsd:element>
<xsd:element name="PivotView" type="PivotViewType" minOccurs="0">
</xsd:element>
<xsd:element name="Selection" type="SelectionType" minOccurs="0">
</xsd:element>
<xsd:element name="AutoFormatAlignment" minOccurs="0">
</xsd:element>
<xsd:element name="AutoFormatBorder" minOccurs="0">
</xsd:element>
<xsd:element name="AutoFormatFont" minOccurs="0">
</xsd:element>
<xsd:element name="AutoFormatName" type="AutoFormatNameType" default="PivotTableClassic" minOccurs="0">
</xsd:element>
<xsd:element name="AutoFormatNumber" minOccurs="0">
</xsd:element>
<xsd:element name="AutoFormatPattern" minOccurs="0">
</xsd:element>
<xsd:element name="GrandTotalString" type="xsd:string" default="Grand Total" minOccurs="0">
</xsd:element>
<xsd:element name="PrintSetTitles" minOccurs="0">
</xsd:element>
<xsd:element name="MergeLabels" minOccurs="0">
</xsd:element>
<xsd:element name="PageFieldStyle" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="PLExport" minOccurs="0">
</xsd:element>
<xsd:element name="ImmediateItemsOnDrop" minOccurs="0">
</xsd:element>
<xsd:element name="ShowPageMultipleItemLabel" minOccurs="0">
</xsd:element>
<xsd:element name="SmallGrid" minOccurs="0">
</xsd:element>
<xsd:element name="TableStyle" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="Tag" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="VacatedStyle" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="HideTotalsAnnotation" minOccurs="0">
</xsd:element>
<xsd:element name="ShowCellBackgroundFromOLAP" minOccurs="0">
</xsd:element>
<xsd:element name="HideDropDowns" minOccurs="0">
</xsd:element>
<xsd:element name="NoViewCalculatedMembers" minOccurs="0">
</xsd:element>
<xsd:element name="VisualTotals" minOccurs="0">
</xsd:element>
<xsd:element name="Location" type="xsd:string">
</xsd:element>
<xsd:element name="PLPivotField" type="PLPivotFieldType" minOccurs="0" maxOccurs="unbounded">
</xsd:element>
<xsd:element name="PLTotal" type="PLTotalType" minOccurs="0" maxOccurs="unbounded">
</xsd:element>
<xsd:element name="DataMember" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="DataAxisEmpty" minOccurs="0">
</xsd:element>
<xsd:element name="DisplayFieldList" minOccurs="0">
</xsd:element>
<xsd:element name="NoAutoFit" minOccurs="0">
</xsd:element>
<xsd:element name="Height" type="xsd:double" minOccurs="0">
</xsd:element>
<xsd:element name="Width" type="xsd:double" minOccurs="0">
</xsd:element>
<xsd:element name="MaxHeight" type="xsd:double" default="32000" minOccurs="0">
</xsd:element>
<xsd:element name="MaxWidth" type="xsd:double" default="32000" minOccurs="0">
</xsd:element>
<xsd:element name="MemberExpand" type="MemberExpandType" minOccurs="0">
</xsd:element>
<xsd:element name="ConnectionString" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="CacheDetails" type="CacheDetailsType" default="True" minOccurs="0">
</xsd:element>
<xsd:element name="FieldListTop" type="xsd:int" minOccurs="0">
</xsd:element>
<xsd:element name="FieldListBottom" type="xsd:int" minOccurs="0">
</xsd:element>
<xsd:element name="FieldListRight" type="xsd:int" minOccurs="0">
</xsd:element>
<xsd:element name="FieldListLeft" type="xsd:int" minOccurs="0">
</xsd:element>
<xsd:element name="PivotAxis" type="PivotAxisType" minOccurs="0" maxOccurs="unbounded">
</xsd:element>
<xsd:element name="VersionUpdateableMin" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="VersionLastUpdate" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="VersionRefreshableMin" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="DefaultVersion" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="PivotField" type="PivotFieldType" maxOccurs="unbounded">
</xsd:element>
<xsd:element name="CubeField" type="CubeFieldType" minOccurs="0" maxOccurs="unbounded">
</xsd:element>
<xsd:element name="CalculatedMember" minOccurs="0">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="Name" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="MemberName" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="ParentUniqueName" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="SourceHierarchy" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="SourceHierarchyLevel" type="xsd:integer" minOccurs="0">
</xsd:element>
<xsd:element name="Formula" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="SolveOrder" type="xsd:integer" minOccurs="0">
</xsd:element>
<xsd:element name="Invalid" minOccurs="0">
</xsd:element>
<xsd:element name="Set" minOccurs="0">
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="PTLineItems" type="PTLineItemsType" minOccurs="0" maxOccurs="unbounded">
</xsd:element>
<xsd:element name="PTSource" type="PTSourceType" minOccurs="0">
</xsd:element>
<xsd:element name="PTFormula" type="PTFormulaType" minOccurs="0" maxOccurs="unbounded">
</xsd:element>
<xsd:element name="PTFormat" type="PTFormatType" minOccurs="0" maxOccurs="unbounded">
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</code>
</pre><center><a href="XMLSchemaCopyright_HV01147162.htm">©2003-2004 Microsoft Corporation. All rights reserved.</a>
Permission to copy, display and distribute this document is available at: <a
href="http://r.office.microsoft.com/r/rlidAWSContentRedir?AssetID=XT010988631033&CTT=11&Origin=HV011232471033"
target="_new">http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp</a></center></body></html>
|
