EXCEL TIP
I have no confidence in Excel's processing of formulas with the Sort or with the Pivot Table. Before I use the Sort or the Pivot Table I always copy my data to a clean worksheet and remove the formulas. You can remove the formulas by using copy-and-paste-special-values-only