If you look at the code that the Excel Macro Recorder creates, you will find that it first sets up PivotCaches before it creates the pivot table. If you port the VB code to Perl, it is a good strategy to follow what the VB code does.