Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i extract data from pivot table to txt file
Hi, i receive daily pivot tables, i need to extract it but its bigger than
66000. how can i extract it to either text file or access file. data can be extracted from pivot table. how do i do it. we don't have access to the data source. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i extract data from pivot table to txt file
You could use a page field to filter the data, so only half the records
are summarized in the pivot table. Double-click on the grand total cell, to extract that data. Change the page field, to show the remaining data, and extract it. From the Excel sheets with extracted data, you can create text files, or move the data to Access. stef wrote: Hi, i receive daily pivot tables, i need to extract it but its bigger than 66000. how can i extract it to either text file or access file. data can be extracted from pivot table. how do i do it. we don't have access to the data source. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Tables, Help? | Excel Discussion (Misc queries) |