How to iterate trough cells in "Power Pivot for Excel" using VBA?

[CPPlus]

Hello! I have a pivot table. When I go to the "Power Pivot" tab in Excel and click "Manage" a window named "Power Pivot for Excel" appears. I have different "sheets" (don't know if this is how they are called in the new window) and I want to copy the contents of a specific sheet to a separate workbook. It is quite big - around 3 million rows, so I can't just copy and paste it. Is there a way to access this data using VBA?

 

[Matt Allington]

Not VBA, but you can use DAX Studio. I wrote about it here. Getting Started with DAX Studio - Excelerator BI