ALM 11.50, QC 11.0, ALM 11.52, Excel Report Generator, ALM Reporting, post processing.
When generating an excel report, post processing fails to create a pivot table. The error is invalid procedure.
The cause is that the pivot table is supposed to be created on a separate worksheet. The Sheets.Add operation does not work with Excel Reporting in ALM.
Replace Sheets.Add with:
And replace any other reference to "Sheet1" with "Sheet4"