Automating PowerPivot Refresh operation from VBA
User Rating: 1 / 5
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.