I have a simple pivot table that refuses to sort certain text items
correctly. I have tried reformating the cells at the sources, clearing the
cell and re-entering. Alpha sorts and subtotals work correctly, just the
pivot table is failing to sort correctly. Any ideas?