Automating PowerPivot Refresh operation from VBA

User Rating: 1 / 5

Star ActiveStar InactiveStar InactiveStar InactiveStar Inactive

Although the latest CTP3 release of PowerPivot has addressed many of the short-comings of the original release (allowing drill-thru for example), there's still one major missing: a published API accessible from VBA (or even .NET).

Like Marco Russo, I would settle for the ability to automate the PowerPivot refresh function. What's doubly annoying about this is that there's obviously an undocumented method of doing this as Predixion are doing it and so are PowerPlanner.





Tags: excel, refresh, vba


2007-2015 VidasSoft Systems Inc.