View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Randy Harmelink Randy  Harmelink is offline
external usenet poster
 
Posts: 122
Default extract data from pivot via vba (Getpivot is not convenient)

Sandip wrote:

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


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