New Records Not Sorted In Pivot Table

[rb80923]

I have a spreadsheet that is made of records from compact disc information. I have made a separate pivot table that shows Artists and Titles. My problem is that some of the new records I have entered are not sorted (sorted first by Artist A to Z).

The new records that have been sorted already have more than one record by Artist. The new records that haven't been sorted are of Artists that are being entered for the first time. How can I get the new records with new Artists sorted into my pivot table?

I have done a Refresh for the pivot table.