was the sorting done at some point locally within the workbooks? If so, I am thinking that this will override the datasource order.
You know, it's possible. I inherited the data sources and reports, and when the database data changed it automatically sorted the new item to the bottom.
I think that I will try to recreate the scenario along the lines you've suggested above and report back.