The sorting process appears not to work when sorting a range that contain links to other ranges with formulas. For example:

Rank Name Total Points Points1 Points2 Points3 Points4 Points5 Points6
1 aaa 25 7 1 8 20 12 9
2 bbb 20 4 2 5 14 9 11
3 ccc 24 6 3 7 12 16 8
etc.

This is a ranking of 6 separate tournaments played during the year (4 best results count). The lowest Total Points must be sorted into Rank 1, etc.
The points1-6 from the 6 tournaments are arrived at with formulas. However, if these Points1-6 are copied into the above range from the original score sheet with =(originating cell), the sorting process doesn't work right.
The Points1-6 must be manually copied into the above range with Paste Special, Values to make the sorting work right.

1. What is the explanation for this?
2. Is there a way to fill them in automatically without disturbing the sorting?

Thank you.