title: Automatically reorder table in excel after refreshing power pivot data
body: <p>I have a table which is sorted by a column "rank" which contains numbers 1-10 sorted from smallest to largest. When I refresh my PowerPivot data the rankings will change, however the order of the table does not update. Is there a way to automatically update the sorting of my table after refreshing the data? </p>