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