Skip to main content
Windward

PivotTables Limitations

Overviewautotag-wiki-logo.png

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?