In a recent project I needed the range of the Grand Totals in any pivottable in Excel. Unfortunately the PivotTable object has no property for this. Solutions I found on the Internet were for specific cases. So I developed a generic solution that I want to share with you.
[Read more…] about The Grand Totals range of a pivottable in ExcelPivotTable
Replace drill-through for Power Pivot and Power BI pivottables in Excel
Excel’s default drill-through for pivottables connected to a datamodel or Power BI dataset is often not very helpful. The add-in PowerDrill for Excel replaces Excel’s drill-through and gives you full control over the drill details.
[Read more…] about Replace drill-through for Power Pivot and Power BI pivottables in ExcelPivottable data connection models
The way a datasource connects to a PivotTable depends on the datasource. In this post an overview of the six connection models that you can create by means of Excel’s userinterface. [Read more…] about Pivottable data connection models