Sorting tables in Excel containing formulas

I’m having what appears to be a common problem with sorting tables in Excel, when they contain formulas.