Applies To:
ALM 11.50, QC 11.0, ALM 11.52, Excel Report Generator, ALM Reporting, post processing.
Issue:
When generating an excel report, post processing fails to create a pivot table. The error is invalid procedure.
Solution:
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.
The Fix:
Replace Sheets.Add with:
ActiveWorkbook.Sheets.Add
ActiveWorkbook.Sheets("Sheet4").Select
And replace any other reference to "Sheet1" with "Sheet4"