Pivot table data
 

Hi All

I've been sent a large pivot table which has been arranged in a particular
format. I want to add some extra data but each time I change the data source
to the revised range, the pivot table refreshes and loses the previous layout
of the pivot table. In fact, even if I don't change anything but just hit the
refresh button, I lose the original layout !! Any idea's why it's doing this
and how can I preserve the original layout of rows/columns etc ????
--
Regards
Swansea Jack