extract data from pivot via vba (Getpivot is not convenient)

S

Sandip

Hi,

We have a tool which accesses the database and produces reports
directly in a pivot table form. The data within the pivot ranges from
300k to 600k lines. (Am using Office 2007 Beta 2, hence possible to
find out the number of total lines by double clicking on the summary
totals)

The rows in the database comprises of more than 10 different
parameters. The Pivot itself hangs if I bring more than 4 or 5
parameters within the rows from the "Page" heading.

Getpivotdata only works if the data is visible. Also if additional
parameters are added or columns are changes, the formula gives a "Ref"
error.

Is it possible to access the database within the Pivot table to
generate summary reports without expanding the Pivot.

Regards
Sandip.
 
R

Randy Harmelink

Sandip said:
Is it possible to access the database within the Pivot table to
generate summary reports without expanding the Pivot.
Click to expand...

How about creating a new summary pivot table from your master pivot
table, then extracting the data from it?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selecting Date Range in a Pivot using VBA 0
Getpivot data dynamic reference 2
Excel 2007 VBA Pivot table fetch records 0
Storing data from pivot tables with adjacent entered data 0
Need help getting data from large table (get pivot data?) 1
Corrupt Pivot Table 0
Pivot table Page field content display? 0
Extract data from Pivot table with VBA 0

Top