How to retrieve original huge data from pivottable?
 

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 ???

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 ???

"ciscopower" wrote:

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 ???

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.