Custom sorting list is working fine when a pivot table is created on the same workbook but if I import or connect data to another workbook and create a pivot table it stops working i.e. data is sorted alphabetically instead.

Could anyone help?