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
|
<html dir="ltr"><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META HTTP-EQUIV="assetid" CONTENT="HV01104902"><META NAME="lcid" CONTENT="1033"><title>PTSource element</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>PTSource element</h1><p>Contains information describing the data source of the PivotTable view.</p><h2>Usage</h2><pre>
<code>
<PTSource />
</code>
</pre><h2>Element Information</h2><table>
<tr>
<td>
<b class="bterm">Element type</b>
</td>
<td><a href="xtcoPTSourceType_HV01105129.htm" id="HV01105129" lcid="">PTSourceType</a></td>
</tr>
<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>Parent Elements</h3><table>
<tr>
<th>Element</th>
<th>Description</th>
</tr>
<tr>
<td><a href="xelePivotTable_HV01104867.htm" id="HV01104867" lcid="">PivotTable</a></td>
<td>Contains information about a PivotTable view.</td>
</tr>
</table><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:element name="PTSource" type="PTSourceType" minOccurs="0" >
</xsd:element>
</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>
|
