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