Hello.

I hope someone can help me as this is driving me crazy!

I have a fairly simple pivot table (linked to an external source). It has date in Mth-yy format (sorted by newest (left) to oldest) in column headings, Brand in Row, and some brand share value in Values.

I have selected it to sort Brand (rows) by values in selected column $D$5. This works fine, however when I refresh the pivot table and more months are added, the reference changes so its still sorting by the original month above (eg $E$5).
I need to always sort by the latest month - which will always be column D.

Any help would be greatly appreciated!


Oh and another weird point - I have another pivot in a separate workbook which is almost identical, and this one does fix the reference when refreshed!!
I've gone through all the pivot options etc, and cannot seem to find anything different.

Thanks