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 stuff
Pivottable 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