in reply to WIN32::OLE excel pivot Chart Title doesn't work

See Using Win32::OLE and Excel - Tips and Tricks.

Also, Excel objects don't have this method:

->PivotChaches->

Replies are listed 'Best First'.
Re^2: WIN32::OLE excel pivot Chart Title doesn't work
by jazzman (Initiate) on Feb 23, 2011 at 05:59 UTC
    Yes, I know. That was my first attempt=) But I have these commented out then.

      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.