| Automating PowerPivot Refresh operation from VBA |
| Written by Goban Saor |
| Thursday, 01 September 2011 21:49 |
|
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.
|
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- Learning PowerPivot and DAX
- PowerPivot's impact on BI pros?
