How to convert a Pivot Table into a Flat File format?

I am an Excel 2003 user and have a pivot table just the way I want it.
I would like to take that and convert it into a flat file format
(removing all the row totals, etc).

Is that possible?

I see in the formatting section that all you can do is make it look
'pretty'...

What I am trying to do is take the pivot output, convert to a flat file
to insert into another dataset that I will pivoting from.

You can turn off the totals, then copy the pivot table, and paste it as
values on another worksheet. There, fill in the blanks, using a
technique shown here:

http://www.contextures.com/xlDataEntry02.html

To turn off the row or column totals, right-click on the pivot table,
and choose Table Options.
Remove the check marks from Grand totals for columns and Grand totals
for rows.

[email protected] wrote:
> I am an Excel 2003 user and have a pivot table just the way I want it.
> I would like to take that and convert it into a flat file format
> (removing all the row totals, etc).
>
> Is that possible?
>
> I see in the formatting section that all you can do is make it look
> 'pretty'...
>
> What I am trying to do is take the pivot output, convert to a flat file
> to insert into another dataset that I will pivoting from.
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html