Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
stef
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
OLAP Pivot table - How to show items with no data ? Timmo Excel Worksheet Functions 1 March 30th 06 06:03 PM
consolidation of tables in excel with text and figures samenvoegen van sheets Excel Worksheet Functions 8 March 2nd 06 03:27 PM
pivot table sort entries that don't yet appear in table rachael Excel Discussion (Misc queries) 11 September 19th 05 11:29 PM
Pivot table, dynamic data formula Excel GuRu Excel Discussion (Misc queries) 3 May 3rd 05 10:45 PM
Pivot Tables, Help? Adam Excel Discussion (Misc queries) 6 March 24th 05 02:35 PM


All times are GMT +1. The time now is 08:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"