Placing Related Powerpivot Data into MS Mappoint 2010

[butlerrbrian]

Here is an interesting scenario I face: I would like to leverage all my powerpivot work into several tables for different colored pushpins in Mappoint. There is very scant information on how to link the two. Anyone had this same challenge?

 

[Derek Brown]

The following site should help you get started:
MP2K Magazine | The Magazine for MapPoint

 

[butlerrbrian]

No mention of Powerpivot in those forums.

 

[Derek Brown]

Probably not, and very unlikely to see anything directly referring to Pivot Tables either.
I would choose to use VBA to extract/format the required data and, again using VBA, produce my MapPoint maps.
In fact, that is how I do it.

 

[dhExcel]

Probably not, and very unlikely to see anything directly referring to Pivot Tables either.
I would choose to use VBA to extract/format the required data and, again using VBA, produce my MapPoint maps.
In fact, that is how I do it.

PowerPivot data cannot be manipulated by VBA.