BAM Error creating pivot table
I'm trying to create a very simple pivot table in Excel 2007 (and BizTalk 2006 BAM Add-In) but as soon as I want to finish the wizard I get this error:
Error Description:
OLE DB error: OLE DB or ODBC error: Cannot connect to the data source '[Microsoft][ODBC Excel Driver] External table is not in the expected format.;S1000'..
Error Source:
Microsoft OLE DB Provider for Analysis Services 2005
If I import the xml specification on a computer with Excel 2003 I can create the pivot with no problems. I've googled on this error bu I couldn't find anything, any help would be appreciated.
This is the exported XML of the sample I'm following:
<?xml version="1.0" encoding="UTF-16"?>
<BAMDefinition xmlns="http://schemas.microsoft.com/BizTalkServer/2004/10/BAM">
<Activity Name="Process Activity" ID="ID96DCDCABC2FA4535BECE3166D29188EE">
<Checkpoint Name="Begin" ID="IDB4A6441169AD457AB2CAF94C643DE7A3" DataType="DATETIME"/>
<Checkpoint Name="EndSuccess" ID="IDFA94478A46DF43749630EC9C423211A6" DataType="DATETIME"/>
<Checkpoint Name="Exception" ID="ID3EB7771FBCA7447D87E8EB2D43B7CF0D" DataType="DATETIME"/>
<Checkpoint Name="Transaction Id" ID="IDB705468FA9414827A2EAE6DDD56D2A02" DataType="NVARCHAR" DataLength="50"/>
<Checkpoint Name="Transaction Type" ID="ID54B9EA6DCF6844928D7C83741A413B5A" DataType="NVARCHAR" DataLength="50"/>
</Activity>
<View Name="ProcessView" ID="IDC4BB2673889B4BB988E6810AB3CEB4E2">
<ActivityView Name="ViewProcess Activity" ID="ID063C7F051E2E4C22990ADC93B0A3336A" ActivityRef="ID96DCDCABC2FA4535BECE3166D29188EE">
<Alias Name="Begin" ID="ID1FA6567A119B4B8AB8066977C3858FF5">
<CheckpointRef>IDB4A6441169AD457AB2CAF94C643DE7A3</CheckpointRef>
</Alias>
<Alias Name="EndSuccess" ID="ID977B9164B21D4B5ABF85D0902D841401">
<CheckpointRef>IDFA94478A46DF43749630EC9C423211A6</CheckpointRef>
</Alias>
<Alias Name="Exception" ID="IDC072F100BE1F461B917D1BCB80664DA3">
<CheckpointRef>ID3EB7771FBCA7447D87E8EB2D43B7CF0D</CheckpointRef>
</Alias>
<Alias Name="Transaction Id" ID="ID3CF14F87ED4B40009E1EBA138673AA9B">
<CheckpointRef>IDB705468FA9414827A2EAE6DDD56D2A02</CheckpointRef>
</Alias>
<Alias Name="Transaction Type" ID="ID20D87D50626F428A90B842B46ED51589">
<CheckpointRef>ID54B9EA6DCF6844928D7C83741A413B5A</CheckpointRef>
</Alias>
<Alias Name="End" ID="IDF948CBA616B74185A376237126E6827B">
<CheckpointRef>IDFA94478A46DF43749630EC9C423211A6</CheckpointRef>
<CheckpointRef>ID3EB7771FBCA7447D87E8EB2D43B7CF0D</CheckpointRef>
</Alias>
<Duration Name="ProcessDuration" ID="ID0540D75A1C294C6B964204A1D704CD8D" TimeResolution="Day">
<FromAliasRef>ID1FA6567A119B4B8AB8066977C3858FF5</FromAliasRef>
<ToAliasRef>IDF948CBA616B74185A376237126E6827B</ToAliasRef>
</Duration>
</ActivityView>
</View>
<Cube Name="ProcessView" ID="ID986282DA2E8E4B8F86B99FEFD64E765E" CreateOlapCube="false" ActivityViewRef="ID063C7F051E2E4C22990ADC93B0A3336A">
<Measure Name="Conut" ID="ID4AA2B0574743402D90E213B2295FBE67" AliasRef="ID1FA6567A119B4B8AB8066977C3858FF5" AggregationFunction="Count"/>
<ProgressDimension Name="ActivityProgress" ID="IDD7D00F0303FB4DE7B437E682FDFE0E2D">
<ProgressStage Name="Started" ID="ID59858BBEFF26418BB2C8FF32A9D4866C" TimeStampAliasRef="ID1FA6567A119B4B8AB8066977C3858FF5">
<ProgressStage Name="Processing" ID="ID5AD66D035E2343B0AB786CC9502612C5" TimeStampAliasRef="ID1FA6567A119B4B8AB8066977C3858FF5"/>
<ProgressStage Name="Completed" ID="IDEB1CD08F623D45D0992F220A2CA4D2D0" TimeStampAliasRef="ID977B9164B21D4B5ABF85D0902D841401"/>
<ProgressStage Name="Failed" ID="ID43CB8FFA060042B7857C1BD32A9868AD" TimeStampAliasRef="IDC072F100BE1F461B917D1BCB80664DA3"/>
</ProgressStage>
</ProgressDimension>
</Cube>
<Extension>
<OWC xmlns:x="urn:schemas-microsoft-com:office:excel"/>
</Extension>
</BAMDefinition>
