1. D

    Pivottable DrilledDown <> ShowDetail

    I can't seem to figure out how to determine which rows (or columns) in a PivotTable are collapsed/expanded. PivotItem.ShowDetail works for some tables but as I understand it DrilledDown is the equivalent for the other types of tables - "data model/OLAP tables". However, while setting the...
  2. S

    Pivot Table DrilledDown

    I am running a macro to pull data from a server into a pivot table. However, each request is sent separately, increasing the query time. Is there a way to combine these types of DrilledDown commands? 'Show detail year ActiveSheet.PivotTables("Microsoft Office PivotTable 10.0").PivotFields(...

Some videos you may like

This Week's Hot Topics