| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel 2007 Pivot Tables
1. How can I create a Pivot Table from a text file, downloaded from a
mainframe database? I have been told this could be done in previous versions of Excel. 2. If I get a new text file each day, how can I refresh the existing Pivot Table, without the necessity of recreating Thank you very much Marsh |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Excel 2007 Pivot Tables
Import the Text file into Excel.
-- Regards Dave Hawley www.ozgrid.com "Marsh" wrote in message ... 1. How can I create a Pivot Table from a text file, downloaded from a mainframe database? I have been told this could be done in previous versions of Excel. 2. If I get a new text file each day, how can I refresh the existing Pivot Table, without the necessity of recreating Thank you very much Marsh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Tables & Excel 2007 | Excel Discussion (Misc queries) | |||
| Pivot tables in Excel 2007 | Excel Discussion (Misc queries) | |||
| Pivot Tables in Excel 2007 | Excel Worksheet Functions | |||
| Pivot Tables in Excel 2007 | Excel Discussion (Misc queries) | |||
| Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Linear Mode
