April 8th, 2010, 02:04 AM
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
|