Hi,

I've little problem in loading XML into PivotTable Object. What's the problem? Is a need to parse the XML?

Dim xml

xml = "<xml xmlns:x="urn:schemas-microsoft-comffice:excel">
<x:PivotTable>
<x:OWCVersion>10.0.0.6619 </x:OWCVersion>
<xisplayScreenTips/>
<x:NoAutoFit/>
<x:Height>297</x:Height>
<x:Width>984</x:Width>
<x:NoAllowPropertyToolbox/>
<x:CubeProvider>msolap.2</x:CubeProvider>
<x:CacheDetails/>
<x:ConnectionString>Provider=MSOLAP.2;Data Source=saoserv009;Initial Catalog=CuboEPM;Client Cache Size=25;Auto Synch Period=10000</x:ConnectionString>
<xataMember>CUBE_EVM</xataMember>
<x:Name>Tabela dinâmica do Microsoft Office 10.0</x:Name>
<x:PivotField>
<x:Name>Project Name</x:Name>
<xourceName>[Project List].[Project Name]</xourceName>
<x:FilterCaption>Project List</x:FilterCaption>
<x:Orientation>Row</x:Orientation>
<x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>
<x:AllIncludeExclude>Exclude</x:AllIncludeExclude>
<x:IncludedMember>
<x:Name>CAIXA - SIDEM - Relatórios Gerenciais - Fase 2.Publicada</x:Name>
<x:UniqueName>[Project List].[All Projects].[CAIXA - SIDEM - Relatórios Gerenciais - Fase 2.Publicada]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>BKB-Altamira - PROJETO ESPECIAL.Publicada</x:Name>
<x:UniqueName>[Project List].[All Projects].[BKB-Altamira - PROJETO ESPECIAL.Publicada]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>Caixa - SIDEM - Correspondente Bancário.Publicada</x:Name>
<x:UniqueName>[Project List].[All Projects].[Caixa - SIDEM - Correspondente Bancário.Publicada]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>CAIXA - SIDEM - Relatórios Gerenciais.Publicada</x:Name>
<x:UniqueName>[Project List].[All Projects].[CAIXA - SIDEM - Relatórios Gerenciais.Publicada]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>CAIXA - SIDEM - Satisfação do Cliente.Publicada</x:Name>
<x:UniqueName>[Project List].[All Projects].[CAIXA - SIDEM - Satisfação do Cliente.Publicada]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>Caixa - SIDEM - Distribuição de Metas.Publicada</x:Name>
<x:UniqueName>[Project List].[All Projects].[Caixa - SIDEM - Distribuição de Metas.Publicada]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>CAIXA - SIDEM - Avaliação de Porte.Publicada</x:Name>
<x:UniqueName>[Project List].[All Projects].[CAIXA - SIDEM - Avaliação de Porte.Publicada]</x:UniqueName>
</x:IncludedMember>
</x:PivotField>
<x:PivotField>
<x:Name>Year</x:Name>
<xourceName>[Time].[Year]</xourceName>
<x:FilterCaption>Time</x:FilterCaption>
<x:Orientation>Column</x:Orientation>
<x:CompareOrderedMembersBy>Name</x:CompareOrderedMembersBy>
</x:PivotField>
<x:PivotField>
<x:Name>Quarter</x:Name>
<xourceName>[Time].[Quarter]</xourceName>
<x:Orientation>Column</x:Orientation>
<x:Position>2</x:Position>
<x:CompareOrderedMembersBy>Name</x:CompareOrderedMembersBy>
</x:PivotField>
<x:PivotField>
<x:Name>Month</x:Name>
<xourceName>[Time].[Month]</xourceName>
<x:Orientation>Column</x:Orientation>
<x:Position>3</x:Position>
<x:CompareOrderedMembersBy>Name</x:CompareOrderedMembersBy>
</x:PivotField>
<x:PivotField>
<x:Name>Days</x:Name>
<xourceName>[Time].[Days]</xourceName>
<x:Orientation>Column</x:Orientation>
<x:Position>4</x:Position>
<x:CompareOrderedMembersBy>Name</x:CompareOrderedMembersBy>
</x:PivotField>
<x:PivotField>
<x:Name>SPI</x:Name>
<xourceName>[Measures].[SPI]</xourceName>
<xourceHierarchy>[Measures].[SPI]</xourceHierarchy>
</x:PivotField>
<x:PivotField>
<x:Name>CPI</x:Name>
<xourceName>[Measures].[CPI]</xourceName>
<xourceHierarchy>[Measures].[CPI]</xourceHierarchy>
</x:PivotField>
<x:PivotField>
<x:Name>Dados</x:Name>
<x:Orientation>Row</x:Orientation>
<x:Position>-1</x:Position>
<xataField/>
</x:PivotField>
<x:PivotField>
<x:Name>CPI</x:Name>
<x:TotalNumber>3</x:TotalNumber>
<x:Orientation>Data</x:Orientation>
<x:Position>2</x:Position>
<x:ParentField>[Measures].[CPI]</x:ParentField>
</x:PivotField>
<x:PivotField>
<x:Name>SPI</x:Name>
<x:TotalNumber>4</x:TotalNumber>
<x:Orientation>Data</x:Orientation>
<x:Position>1</x:Position>
<x:ParentField>[Measures].[SPI]</x:ParentField>
</x:PivotField>
<x:PLTotal>
<x:Name>ACWP</x:Name>
<x:Caption>ACWP</x:Caption>
<x:TotalNumber>0</x:TotalNumber>
</x:PLTotal>
<x:PLTotal>
<x:Name>BCWP</x:Name>
<x:Caption>BCWP</x:Caption>
<x:TotalNumber>1</x:TotalNumber>
</x:PLTotal>
<x:PLTotal>
<x:Name>BCWS</x:Name>
<x:Caption>BCWS</x:Caption>
<x:TotalNumber>2</x:TotalNumber>
</x:PLTotal>
<x:PivotData>
<x:Top>0.0</x:Top>
<x:TopOffset>0</x:TopOffset>
<x:Left>0.0</x:Left>
<x:LeftOffset>0</x:LeftOffset>
</x:PivotData>
</x:PivotTable>
</xml>"

PTable.XMLData = xml

Thanks
Victor Amano Izawa