Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 ??? |
#2
|
|||
|
|||
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 ??? |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is the order of my data table opposite from graph? | Charts and Charting in Excel | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Can I retrieve deleted data? | Excel Discussion (Misc queries) | |||
Charting data ranges that change | Charts and Charting in Excel |