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
|
<html dir="ltr"><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META HTTP-EQUIV="assetid" CONTENT="HV01105129"><META NAME="lcid" CONTENT="1033"><title>PTSourceType 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>PTSourceType complexType</h1><p>Contains information describing the data source of the 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="xeleCacheFile_PTSourceType_HV01104446.htm" id="HV01104446" lcid="">CacheFile</a></td>
<td>Specifies the name of the XML file that contains the PivotTable source data.</td>
</tr>
<tr>
<td><a href="xeleCacheIndex_PTSourceType_HV01104449.htm" id="HV01104449" lcid="">CacheIndex</a></td>
<td>Specifies the PivotCache associated with this PivotTable.</td>
</tr>
<tr>
<td><a href="xeleDataMember_PTSourceType_HV01104513.htm" id="HV01104513" lcid="">DataMember</a></td>
<td>Contains either the MDX query that represents the source of the data for an OLAP-based PivotList control or the value XLDataSource.</td>
</tr>
<tr>
<td><a href="xeleMissingItemsLimit_HV01104747.htm" id="HV01104747" lcid="">MissingItemsLimit</a></td>
<td>Specifies the maximum number of PivotItems not appearing in any records that are to be retained when a PivotTable view is refreshed.</td>
</tr>
<tr>
<td><a href="xeleVersionRefreshableMin_PTSourceType_HV01105062.htm" id="HV01105062" lcid="">VersionRefreshableMin</a></td>
<td>Specifies the minimum version of Excel required to be able to refresh a PivotTable cache.</td>
</tr>
<tr>
<td><a href="xeleVersionLastRefresh_PTSourceType_HV01105057.htm" id="HV01105057" lcid="">VersionLastRefresh</a></td>
<td>Specifies a number indicating which version of Excel last refreshed the PivotTable view.</td>
</tr>
<tr>
<td><a href="xeleRefreshName_HV01104929.htm" id="HV01104929" lcid="">RefreshName</a></td>
<td>Specifies the name of the user who last refreshed the PivotTable view.</td>
</tr>
<tr>
<td><a href="xeleRefreshDateCopy_HV01104925.htm" id="HV01104925" lcid="">RefreshDate</a></td>
<td>Specifies the date on which the PivotTable view was last refreshed.</td>
</tr>
<tr>
<td><a href="xeleRefreshDateCopy_HV01104925.htm" id="HV01104925" lcid="">RefreshDateCopy</a></td>
<td>Specifies the date on which the PivotTable view was last refreshed. Duplicates the RefreshDate element.</td>
</tr>
<tr>
<td><a href="xeleConsolidationReference_PTSourceType_HV01104498.htm" id="HV01104498" lcid="">ConsolidationReference</a></td>
<td>Describes the file and worksheet range that the PivotTable view is based on when the PivotTable view is created from an Excel list or database.</td>
</tr>
<tr>
<td><a href="xeleNoSaveData_PTSourceType_HV01104801.htm" id="HV01104801" lcid="">NoSaveData</a></td>
<td>Specifies a Boolean indicating whether the supporting PivotTable data should be saved.</td>
</tr>
<tr>
<td><a href="xeleQuerySource_PTSourceType_HV01104909.htm" id="HV01104909" lcid="">QuerySource</a></td>
<td>Describes the data source that the PivotTable view is based on when the PivotTable view is created from an external source.</td>
</tr>
<tr>
<td><a href="xeleSourceConsolidation_HV01104983.htm" id="HV01104983" lcid="">SourceConsolidation</a></td>
<td>Describes the files and worksheets range that the PivotTable view is based on when the PivotTable view is created from multiple consolidation ranges.</td>
</tr>
<tr>
<td><a href="xeleBackgroundQuery_HV01104436.htm" id="HV01104436" lcid="">BackgroundQuery</a></td>
<td>Specifies a Boolean indicating whether the supporting data for the PivotTable view is read in the background, allowing the user to do other work in Excel.</td>
</tr>
<tr>
<td><a href="xeleCubeSource_HV01104505.htm" id="HV01104505" lcid="">CubeSource</a></td>
<td>Specifies a Boolean indicating if the data source is an OLAP cube.</td>
</tr>
<tr>
<td><a href="xeleDisableRefresh_PTSourceType_HV01104544.htm" id="HV01104544" lcid="">DisableRefresh</a></td>
<td>Specifies a Boolean indicating if PivotTable refresh is disabled.</td>
</tr>
<tr>
<td><a href="xeleHasNoRecords_HV01104659.htm" id="HV01104659" lcid="">HasNoRecords</a></td>
<td>Specifies a Boolean indicating that the last refresh returned zero records from the data source.</td>
</tr>
<tr>
<td><a href="xeleOptimizeCache_HV01104823.htm" id="HV01104823" lcid="">OptimizeCache</a></td>
<td>Specifies that the PivotTable view use less memory to store the records from the data source.</td>
</tr>
<tr>
<td><a href="xeleRefreshOnFileOpen_PTSourceType_HV01104931.htm" id="HV01104931" lcid="">RefreshOnFileOpen</a></td>
<td>Specifies that data be fetched whenever the spreadsheet is opened.</td>
</tr>
</table><h3>Attributes</h3><p>None.</p><h2>Definition</h2><pre>
<code>
<xsd:complexType name="PTSourceType" >
<xsd:all>
<xsd:element name="CacheFile" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="CacheIndex" type="xsd:int" default="1" minOccurs="0">
</xsd:element>
<xsd:element name="DataMember" type="xsd:string" default="XLDataSource" minOccurs="0">
</xsd:element>
<xsd:element name="MissingItemsLimit" type="xsd:int" default="1" minOccurs="0">
</xsd:element>
<xsd:element name="VersionRefreshableMin" type="xsd:int" minOccurs="0">
</xsd:element>
<xsd:element name="VersionLastRefresh" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="RefreshName" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="RefreshDate" type="xsd:dateTime" minOccurs="0">
</xsd:element>
<xsd:element name="RefreshDateCopy" type="xsd:dateTime" minOccurs="0">
</xsd:element>
<xsd:element name="ConsolidationReference" type="ConsolidationReferenceType" minOccurs="0">
</xsd:element>
<xsd:element name="NoSaveData" minOccurs="0">
</xsd:element>
<xsd:element name="QuerySource" type="PTQuerySourceType" minOccurs="0">
</xsd:element>
<xsd:element name="SourceConsolidation" type="SourceConsolidationType" minOccurs="0">
</xsd:element>
<xsd:element name="BackgroundQuery" minOccurs="0">
</xsd:element>
<xsd:element name="CubeSource" minOccurs="0">
</xsd:element>
<xsd:element name="DisableRefresh" minOccurs="0">
</xsd:element>
<xsd:element name="HasNoRecords" minOccurs="0">
</xsd:element>
<xsd:element name="OptimizeCache" minOccurs="0">
</xsd:element>
<xsd:element name="RefreshOnFileOpen" minOccurs="0">
</xsd:element>
</xsd:all>
</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>
|
