Using VBA to enhance interactivity of PowerPivot reports

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

PowerPivot currently has no programmatic interface, so there is really no automated way to leverage its capabilities (other than those provided by PowerPivot for SharePoint). However, we must remember that one way to consume PowerPivot data is through an Excel pivot table (there are others, like Excel Cube functions). Pivot tables do have an API, which allows for a certain degree of programmatic interactivity with PowerPivot data.


Tags: refresh, script, vba


2007-2015 VidasSoft Systems Inc.