Skip to main content

XlPivotTableSourceType enumeration

pecifies the source of the report data.

Name Value Description
xlConsolidation 3 Multiple consolidation ranges.
xlDatabase 1 Microsoft Excel list or database.
xlExternal 2 Data from another application.
xlPivotTable -4148 Same source as another PivotTable report.
xlScenario 4 Data is based on scenarios created using the Scenario Manager.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>