Not saying you should, but if you use xlsx you could manipulate the XML directly. The XLSX is a zip file, if you rename it and then open it there are various folders/XML docs. At a rough guess I think \xl\pivotTables\pivotTable1.xml is probably the one to edit (of course this is assuming the file already has pivot table and it is called pivotTable1). You could read up on the Microsoft open document format if your interested in reading/writing directly though its a bit of a chore.
... View more
