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.