I have a similar problem. I have a pivot table that I update on a
monthly basis. It has company name and region followed by units and
volume in the data area. within each region, the companies are listed.
I then sort the companies descending by volume to see who is the
highest in each region. My problem is that whenever I refresh the pivot
table I loose that formatting and have to re-sort each region again. Is
there a way to make the sort "stick".

Hope that all made sense.

Thanks in advance for any help provided.


--
jesterhs
------------------------------------------------------------------------
jesterhs's Profile: http://www.excelforum.com/member.php...o&userid=20902
View this thread: http://www.excelforum.com/showthread...hreadid=380503