to get things back into line you need to follow the same process as if you
had itmes in the list which no longer existed in the source data. here is a
link to try...

http://www.contextures.com/xlPivot04.html
--
HTH...

Jim Thomlinson


"pepperds" wrote:

Hi,

MS Excel in MS Office 2003

I've been using a pivot table for over 18 months, which is updated every
week with financial information for a set of countries' products. The data
contained goes back approximately 30 months. The list of countries numbers
approximately 20, the list of products approximately 200, we would generally
add new products every week or two.

In the pivot table PAGE section, I select either [or both] Country &
Product. COLUMN is Week by Week, ROW the financial information. My query
relates to the selection of Country & Product from the Page Drop Down... it
is no longer sorted alphabetically. every Time I add a new product it
appears at the bottom of the list. Is there a way that this list is auto
sorted?

I hope this makes sense, if not I can send a screenshot if anyone can help.

Many thanks in advance

DP