View Single Post
  #1   Report Post  
ciscopower
 
Posts: n/a
Default 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 ???