Skip to main content

PivotTables Limitations


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.
  • Was this article helpful?