A list of current limitations in Excel PivotTables implementation:
- Output to PDF is not supported
- A PivotTable is non-movable and expandable. This means it can’t be placed in a worksheet containing other dynamic contents, e.g. a ForEach loop. So, place the PivotTables in separate worksheets.
- A data source for a PivotTable can’t contain more than Z columns.
- A PivotTable can use only by row expandable ForEach loops. If you have a ForEach loop that expands by columns, that won’t work.