How to retrieve original huge data from pivottable?

C

ciscopower

I have a excel file with a pivottable , and pivottable's source data is from
access database( more than 800000 records), and now, I have only excel file
and without access file, but I must get the original records for my work? How
can I do?

I try use the VBA pivotcache object ,but I failed , for pivotcache object
has no methods to export data. Someone can help me ???
 
C

ciscopower

further, when I click pivottable to show details , because there are too more
records to show, excel only show 65535 of 800000, I lost remain records.

How can I get original huge data all from the pivottable of excel ???
 
D

Debra Dalgleish

Instead of double-clicking on the grand total cell, double-click on one
of the subtotals, if it will have fewer than 65536 records.

Or, move some fields to the page area, and filter the pivot table by one
or more of the page fields. Then, double-click the grand total.
 
C

ciscopower

because there are more than 800,000 records , I can't show details records in
one worksheet , and Debra Dalgleish told me to filter page to show details
fewer than 65535 to fit in one worksheet , but with 800,000 records I will
use 13 worksheets to show all of the records , that's impossible , for I have
5 files like this and will do the same thing every week!

May someone tell me how to retrieve detail records from pivottable use VBA
or other ways , so that I can get the original data and put them into access
database?
Thanks for help.
 
Top