Hi
I have 4 workbooks with customer information in them.
I bring them in to one file using consolidated pivot table.
The problem is when I have the information - I cannot
manipulate it ie: Drag around the columns and Rows - is
this possible at all?

Thanks

Ann

If you create a Pivot Table from multiple consolidation ranges, you
won't get the same pivot table layout that you'd get from a single
range. There's an example he

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

If possible, store your data in a single worksheet, with a column
toidentify the customer, and you'll have more flexibility in creating
the pivot table.


Ann Shaw wrote:
Hi
I have 4 workbooks with customer information in them.
I bring them in to one file using consolidated pivot table.
The problem is when I have the information - I cannot
manipulate it ie: Drag around the columns and Rows - is
this possible at all?

Thanks

Ann


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

It is very restricted using consolidated tables

Debra Dalgleish has some info here

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

--
Regards,

Peo Sjoblom


"Ann Shaw" wrote in message
...
Hi
I have 4 workbooks with customer information in them.
I bring them in to one file using consolidated pivot table.
The problem is when I have the information - I cannot
manipulate it ie: Drag around the columns and Rows - is
this possible at all?

Thanks

Ann