<?xml version="1.0" encoding="windows-1252"?>
<node id="651880" title="Re^3: WIN32::OLE Excel Pivot Table Grief" created="2007-11-20 02:56:31" updated="2007-11-19 21:56:31">
<type id="11">
note</type>
<author id="123953">
strat</author>
<data>
<field name="doctext">
&lt;p&gt;I think the error is earlier. If you add the following lines to your code, it will tell you where:&lt;/p&gt;
&lt;code&gt;
use Win32::OLE::Const 'Microsoft Excel'; # instead of the constants

Win32::OLE-&gt;Option( Warn =&gt; 3 );
&lt;/code&gt;
&lt;p&gt;something seems to be wrong at CreatePivotTable&lt;/p&gt;
&lt;code&gt;
$_app_object-&gt;ActiveWorkbook-&gt;PivotCaches-&gt;Add({SourceType =&gt; xlDa
+tabase, SourceData =&gt; 'Sheet1!R1C1:R4C3'})-&gt;CreatePivotTable({TableDe
+stination =&gt; 'Sheet1!R8C3', TableName =&gt; 'PivotTable1', DefaultVersio
+n =&gt; xlPivotTableVersion10});
&lt;/code&gt;

&lt;!-- Node text goes above. Div tags should contain sig only --&gt;
&lt;div class="pmsig"&gt;&lt;div class="pmsig-123953"&gt;
&lt;P&gt;
Best regards,&lt;BR&gt;
perl -e "s&gt;&gt;*F&gt;e=&gt;y)\*martinF)stronat)=&gt;print,print v8.8.8.32.11.32"
&lt;/div&gt;&lt;/div&gt;</field>
<field name="root_node">
651561</field>
<field name="parent_node">
651678</field>
</data>
</node>
